March 31, 2009 at 5:20 pm
Hi All,
I'm fairly new to SSMS and have experienced some frustratingly long delays when opening various dialogs. For example:
If I right click a database->tasks->export data… it takes 1min 40sec for the dialog to appear.
Opening a job then going to steps->edit - it takes 45sec for the dialog to appear
It doesn't seem to make a difference if the database is empty or loaded up with data. In contrast, on the instance of SQL server 2005 on my desktop, it takes 5 seconds for the first of the dialogs noted above to appear.
The problematic instance is a VM running 64bit Windows 2003 Server on ESX with 16GB RAM and 4 E5450 CPU cores available.
The systems administrators are starting to push back saying that this is normal performance but just wanting to check with other users of SS2005 whether they get similar response times?
Thanks,
NR
March 31, 2009 at 7:36 pm
One of the sys admins found a known issue about this - http://sql-server-performance.com/Community/forums/p/2148/2148.aspx
The "solution" is to disable the CRL check in IE.
Open Internet Explorer
Go to Tools -> Internet Options -> Advanced
In the Security section uncheck "Check for publisher's certificate revocation"
This has dramatically reduced the time to open SQL Server and also makes the export wizard come up almost instantly for _most_ users. I'm still trying to work through an issue where its still takes 30s for some users, but I think that might be related to some configuration of their profiles/DB privs. Will post again if I resolve that one.
Thanks,
NR
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply