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?