April 22, 2009 at 9:36 am
I am having an issue specifically related to the SSMS itself. It is like there is some 5 to 10 second delay on almost everything in there now. So I pull up a list of the tables in the database and that is fine. But when I right click the table, it may take 5 to 10 seconds for that menu to show up. So then clicking Open Table or Modify may take another 5 to 10 seconds. If I try to run the query to pull back the data, I get the "Executing Query. Waiting for response from data source" message for another 5 to 10 seconds, then the query runs. It may just be one record in the table, it doesnt seem to matter, it still has that lag. Now I can take that same query and open up a New Query window and it will run right away. Something just seems to have started causing this lag for everything else in SSMS and I can not for the life of me figure out what it is. I saw some posts about turning off online help but that didnt do anything for me. Startup time is fine for it, the SSMS loads quickly, but once inside it just drags.
I think there was a firewall change recently that removed port 80 from this server so that it would not be internet accessible.
Performance from the web application still seems fine, but managing the databases is incredibly slow now.
April 22, 2009 at 10:16 am
Is this a LOCAL or a REMOTE server?
If it's REMOTE, try Remote Desktop and use SSMS locally to see if such problem exists
Any 3rd party plugin for SSMS? like RedGate, or SSMS Tools Pack, etc....
I might install SSMS 2008 to see if it will work without issues too 🙂
April 22, 2009 at 10:52 am
This is running from the web server that uses the database server which is on a different box.
We did install a trial of the Red Gate SQL bundle that had expired and was removed. But it does still have the grayed out boxes for SQL Refactor and SQL Prompt up at the top of SSMS.
I tried running SSMS on the server itself and it is better, especially once a table has been opened and you actually execute that query. You dont have that huge delay before it appears to really do anything, but it still can take almost 10 seconds to just open that one table with one record in it. So using it on the server itself is much more manageable, I just dont understand the reason for the incredibly slow performance when managing from the web server SSMS.
Dan
April 22, 2009 at 4:01 pm
We did install a trial of the Red Gate SQL bundle that had expired and was removed. But it does still have the grayed out boxes for SQL Refactor and SQL Prompt up at the top of SSMS.
Dan
Hi Dan,
The following help page will show you how to remove the greyed out SSMS menus:
http://help.red-gate.com/help/SQLPrompt3/0/en/Topics/SPT_Uninstalling.html
Kind regards,
David
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply