MSQL_XP lastwaittype in sysprocesses when doing log restore.

Forum for users of Redgate's SQL Backup tool

MSQL_XP lastwaittype in sysprocesses when doing log restore.

Postby swirl80 » Fri Sep 11, 2009 9:24 am

I've been trying to temporarily move our reports server to another box and when i go live with it the log restores get slower and slower. On investigation i've noticed that when the restore job starts it'll restore the first database file then wait for around 5-10mins before moving onto the next file. When this is happening i've noticed a lastwaittype of MSQL_XP and the waittime going up and up. I understand what this waittype is but can't work out why its taking so long to clear as it clears almost instant on our current box (which is exactly the same model / spec as the one i'm trying to move it to).

So, a job to restore 17 log files which should take no more than 10mins can take up to an hour, if not longer.

I've just installed v5.4 (from 5.3) to see if this improves the issue but i've restarted the sql service which may have cleared any buffer / caching issues that i was having so will report back later.

Is there any known issues as to why this could be??
Posts: 21
Joined: Thu Oct 23, 2008 3:26 pm

Postby eddie davis » Mon Sep 14, 2009 7:55 pm

Thank you for your post into the forum and sorry that you are experiencing this problem.

How many concurrent SQL Backup tasks to you have running?

Can you please check the SQL Server Error Logs, do you have any entries that are reporting locks or deadlocks to the msdb database by the SQBCoreService.exe?

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1146
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest