Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Why does MS SQL Server Management Studio almost freeze up my computer while it restores? It makes it so when I click on the clock it takes seconds for the calendar to open. I don't see why this should be since I have 4 gigs of ram and a dual core CPU.

share|improve this question

3 Answers 3

I used to see this behaviour a lot too.

For me I believe it was because I was I/O bound on my system drive. I moved the .mdfs and .ldfs off my system drive onto a secondary drive and this stopped the machine freezing up during restores.

share|improve this answer

Are you restoring to a database on your computer? Perhaps you are I/O bound.

Before starting the restore fire up Task Manager and keep an eye on Memory and Proc usage. If running Vista or Windows 7 start up the Resource Monitor instead. That will easily tell you where the bottleneck is when a restore is running.

share|improve this answer

This is an educated guess but I would expect the Management Studio is trying to reconnect to your database or databases as it thinks that there has been an interruption in the connection, you could try shutting down the Management Studio and then hibernating the computer to see whether this is definitely the problem?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.