extreme slow connection using QA or EM

[NilsBevaart]

When connecting to my SQL Server using the EM or QA, the connection takes a few minutes when building the database list. The performance monitor shows memory and processor capacity at less than 5%, indicating no bottleneck in this area. The diskqueue length, however, is up to 100.000 at this point.
After the connection is astablished, the server is quick enough. All manual connections are very quick. Also retreiving the list of databases or objects by hand are quick (use master select * from sysdatabases / select * from sysobjects)

I log on using my windows account. I am a SA on the server (SQL2000 / Win2K3)

Any tips on where to look for this is welcome.

Nils Bevaart

 

[hmckillop]

I remember seeing this exact post before and it was answered, but I cant seem to find it. If you are willing to search through the posts you should find it.
It might be to do with the amount of databases connected and it tries to establish all of them prior to opening, once this is done then it knows whats available. (clutching at straws).
Sorry cant be of more help.



"I'm living so far beyond my income that we may almost be said to be living apart