November 12, 2013 at 7:31 am
Is it normal for this lastwaittype to last for the entire duration of a backup database command? We're seeing the waittime just continue to tick up until the backup job finishes. I'm wondering if that is a sign of some kind of problem on the storage or infrastructure.
November 19, 2013 at 6:44 am
Could be a disk bottleneck, or latency if you're backing up to a network share.
There's some discussion and good advice here:
[font="Courier New"]sqlmunkee[/font]
[font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]
November 23, 2013 at 8:33 pm
DoolinDalton (11/12/2013)
Is it normal for this lastwaittype to last for the entire duration of a backup database command? We're seeing the waittime just continue to tick up until the backup job finishes. I'm wondering if that is a sign of some kind of problem on the storage or infrastructure.
Hi Did you find your answer already?
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply