All of a sudden, DB restore very slow

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » All of a sudden, DB restore very slow

All of a sudden, DB restore very slow

Rate Topic

Display Mode

Topic Options

Author

Message

matt_jk

Posted Tuesday, August 02, 2011 5:59 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 7:20 AM
Points: 7, Visits: 69

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

Ninja's_RGR'us

Posted Tuesday, August 02, 2011 7:08 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:03 PM
Points: 21,376, Visits: 9,581

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) Wink

.

New fileserver backup running at the same time?

Post #1153215

matt.jonas

Posted Friday, August 31, 2012 8:13 AM

Forum 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

RP_DBA

Posted Friday, August 31, 2012 12:56 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, June 06, 2013 2:35 PM
Points: 580, Visits: 816

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) Wink

"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 »

Permissions