November 10, 2010 at 6:58 am
Hello,
Maybe it's a big noob question, but can anybody tell me the difference between the Backupbuffer and Backup I/O wait stats?
The SQL Server 2005 waits and queues best practices article tells me no difference between them.
Description: Occurs when a backup task is waiting for data, or is waiting for a buffer in which to store data. This type is not typical, except when a task is waiting for a tape mount.
Description (for both)
Check backup tape drive
The only difference so fas I've found was that backupbuffer is a new wait stat in SQL Server 2005.
I checked google and Sqlservercentral forums, but couldn't find a satisfying answer. Sorry if I haven't looked deep enough.
Thank you for the help in advance!
Tim
November 10, 2010 at 7:03 am
Backup I/O wait stats means sql server is waiting for IO to complete for the backup process.
No idea about the other one.
November 10, 2010 at 7:16 am
Thank you very much for the reply!
Can anybody else clarify the backupbuffer?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply