Red Gate forums :: View topic - MSQL_XP lastwaittype in sysprocesses when doing log restore.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

MSQL_XP lastwaittype in sysprocesses when doing log restore.

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
swirl80



Joined: 23 Oct 2008
Posts: 21

PostPosted: Fri Sep 11, 2009 10:24 am    Post subject: MSQL_XP lastwaittype in sysprocesses when doing log restore. Reply with quote

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??
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 939
Location: Red Gate Software

PostPosted: Mon Sep 14, 2009 8:55 pm    Post subject: Reply with quote

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
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group