We have noticed that quite frequently, SQL Server Management Studio is somewhat sluggish with expanding lists for tables, opening stored procedures, opening files, etc.
Executing queries seems to be very quick though.
The machine that has SQL 2005 is 2.8 GHz with 512 MB of RAM.
Any idea why SQL Server Management Studio would seem somewhat sluggish?
That is really not very much memory for SQL Server (and the OS). I recommend adding additional memory and comparing the times -I think you will be pleased with the effect.|||Thanks. Got the order from the boss to bump it up to 2.5 GIG ram. I'll let you know how it performs after the upgrade.
No comments:
Post a Comment