April 3, 2012 at 8:55 am
Hi,
I am working on a development server and am restoring databases via SSMS for now. However, when I reach the dialog box to add a backup file (From device) and click Add, the interface hangs for a bit and occasionally times out.
Does anyone know why this part of a restore would take so long, and how I would troubleshoot it? We're using a virtual server attached to our SAN with SQL Server 2008 R2 Enterprise Edition. Let me know if more information is needed to explain the problem.
Thanks for any help!
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 3, 2012 at 11:33 am
From the server where you are restoring, are you able to get to the share where you have the back up? Do you see high IO waits on the VS?
This look more like Server issue.
-Roy
April 3, 2012 at 12:50 pm
Thanks for your reply. I am doing the restore from the SSMS 2008 application on my desktop computer. However, the delay is still quite noticeable (5-10 seconds) when I use the SSMS 2008 application on the SQL dev server itself.
How would you advise me to check for high IO waits on the VS -- Monitor performance counters on the server while carrying out the restore Add operation?
Thanks again,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 3, 2012 at 1:40 pm
You can check the performance counter on the OS level using performance dashboard.
-Roy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply