Subscribe

SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server - BobMgrGetBuf Sort Big Output Buffer write not complete after 60 seconds

02 January,2013 by Jack Vamvas

Sometimes you may see this message in the SQL Server Error Log files

 

 BobMgrGetBuf Sort Big Output Buffer write not complete after 60 seconds

 

It’s associated with IO subsystem issues , other common errors appearing and related are:

 

SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file

 

Read more on  IO Requests taking longer than 15 seconds to - SQL Server DBA

The message relates to large SORTS , probably the TempDB. Bob is the Big Output Buffer. Writres are heavy sequential and occur  on transit tables .During the heavy sequential writes, it is possible the disk IO cannot maintain the resource requirements.

 There are two options :

1)Reduce the workload

2)Add resources

Reducing the workload could mean : a) make queries more efficient and can be achieved through analysing the query Execution Plan, b)  review index usage. Both options  can be quick wins without much justification required in spending terms.

Justifying adding more resource such as  disk resource can be trickier – disk can be expensive but including management of the disk can increase costs.

 

Other options:

1)       If relevant – use Lock Pages in Memory

2)       Work with network \ storage administrators to identify the bottleneck . To identify what is delaying the IO. The bottleneck can occur across the whole environment – such as SVC, network switches and Disk arrays.

Read More

TempDB performance and strategy checklist - SQL Server DBA

IO Requests taking longer than 15 seconds to - SQL Server DBA

 Powershell,PSEexec and lock pages in memory – made easy


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer