SQL Server 2005 Management Studio is Slower than Molasses!

SQL Server 2005 Management Studio is Slower than Molasses!

SQL Server Management Studio 2005 is so slow that I often want to use something command-line just so I can move on with my life and quit waiting for the stupid GUI to load. Have you ever run an update command and have the entire window lock up on you while the query is executing? Those are scary moments right there. How can I speed up the management studio? Is there a "lightweight" alternative?

Asked by: Guest | Views: 271

Total answers/comments: 2

Comments display order:

Guest [Entry]

"3 Questions for you:

Is you machine a low end machine? If yes, upgrade. (May or may not be possible. But try to run Management Studio with minimum other apps running). (It works fine on my 2.45 GHz 845 Intel Chipset Motherboard with 1 GB RAM Machine)
Are you connecting to a remote SQL Server? If yes check the network. Make sure that it is not clogged & is fast enough.
Check if TCP/IP is enabled (From SQL Server Configuration Manager).
Named Pipes are slow for remote connections (Even for local connections)."

Guest [Entry]

"I had the same issue with SSMS2k5.

I've switched from 'Tabbed documents' to 'MDI environment' in Tools-->Options-->Environment, and it works again well."