Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

All of a sudden, DB restore very slow Expand / Collapse
Author
Message
Posted Tuesday, August 2, 2011 5:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 23, 2014 7:56 AM
Points: 7, Visits: 76
Nightly, database from server1 is backed up, the dump file copied to server2, and then restored on server2.

The copy takes about 45 min, and the restore used to be about an hour. A week ago, for no reason that we can think of, the restore just decided to start taking 4 to 5 hours. We loaded on the pssdiag tool and ran it all night. Checked for blocking contention through the night, there is none. The perfmon output is so huge I'm not sure what to look for. Nothing changed on the machine, nothing installed. Disk array shows no bad disks, all error logs are clean. Can anybody shed some light on what to look for, before we end up calling MS support?
Post #1153207
Posted Tuesday, August 2, 2011 7:08 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 4:15 AM
Points: 20,581, Visits: 9,619
Network?


A bit early to waste a call with PSS (unless you got them for free).

SOMETHING changed, you just need to figure out what.


Antivirus?

Slight change in san config (assume they lie) .

New fileserver backup running at the same time?
Post #1153215
Posted Friday, August 31, 2012 8:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 11:23 AM
Points: 7, Visits: 65
I am having the exact same issue. There was no change in disk consumption on either server (prod and backup). Additionally, the log files show that the data and log pages created are relatively on par with what they have been.
Post #1352834
Posted Friday, August 31, 2012 12:56 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, October 2, 2014 12:30 PM
Points: 624, Visits: 867
Assuming you're using a SAN here - are you working with a dedicated or shared array?

Ninja's_RGR'us (8/2/2011)
Slight change in san config (assume they lie) .

"Nothing's changed. <hours later> We patched the controller but that wouldn't have affected the db."


_____________________________________________________________________
- Nate

@nate_hughes
Post #1353057
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse