views:

63

answers:

2

My microsoft Sql Server Management Studio is slow. And by slow I mean >1minute to render a context menu-slow. All other things work perfectly fine. The connection to the database itself is not slow (my app works just fine and context menus don't need connection to the DB anyway I guess)..

Anybody has any idea what I should check to solve this?

--EDIT--

  • Cpu is aroun 3%
  • Gigs of free ram
  • Only clicking right on a table in the object explorer, nothing else
  • the database is remote
  • It's the full version of MSSQLMS
  • No system logging errors
  • Reinstall didn't do jack

UPDATE

I installed Toad for SQL and everything works super smooth there. Actually, I find it way more productive then MSSql ever was for me. It's not really an answer to my question, but it certainly a solution.

A: 

Have you installed any add-ins/plugins? Those might be the source of the problem.

Conrad
nope, just barebone
borisCallens
A: 

Does this behavior occur for all SQL Servers you connect to, or just a few in particular? If it's only certain ones, it may be a really slow SQL Server - to get any context menus or list databases, it has to execute some queries against the remote servers to collect information, and if they're less than responsive, SSMS will be too.

rwmnau
No, it's against all DB.
borisCallens