all groups > sql server misc > november 2005 >
You're in the

sql server misc

group:

Enterprise Manager - problem


Enterprise Manager - problem Mr Curious
11/22/2005 10:25:04 AM
sql server misc:
I have a problem with Enterprise Manager - when I refresh list of tables or
databases it hangs (is not responding) for long time - about 10-30 minutes.
What is more important during my refreshement users are unable to work
normally - it hangs entire server.
Some other details:
1. I am only dbo of one database with no administrative privilges.
2. There are no problems with Query Analyzer
3. Problem is related to one particular server - I don't have these
difficulties with my local instance of SQL Server.



Is there any solution of this problem?

Cheers.

Re: Enterprise Manager - problem Danny
11/23/2005 1:20:47 AM
Sounds like a blocking issue. During the hang are there spids that are
blocked?

[quoted text, click to view]

AddThis Social Bookmark Button