When running SQL Server Management Studio 2008 on a Win7 64bit machine you might stumble upon poor, very poor performance. Clicking on a table results in waiting for 10-20 seconds before being able to do anything, doing a select would again take an eternity. The reason is unknown to me (sorry, I don’t feel like reading tons of articles and kb notes).

Still I got it fixed. Just two steps:
– set the management studio to run in XP SP3 compatibility mode
– if you have the UAC turned off, turn it on on the first level (raise the level from the bottom one notch)

Now it’s working like a charm.

2 Responses to “SQL Server Management Studio 2008 running slow”

  1. Ethan Seftick says:

    Howdy, I figured you most likely are able to help me. I have an MSSQL .ldf and .mdf file that I have to restore. Any ideas on how to do this? Thanks

  2. admin says:

    I think this post will help you

Leave a Reply