Time-out buffer latch error while rebuilding indices

• msumption

  SSC Enthusiast

  Points: 183

  More actions

  September 7, 2011 at 11:50 am

  #256637

  I was advised to post this as a new topic (so sorry for the re-post from another thread).

  I have encountered an error situation while a database maintenance job was running and failed on the "Rebuilding indices" step of the job. The errors from the event log are listed below in order. There have been HD failures in the past, but on the C: drive, not the F: drive (which is actually a SAN) where the DB files are located. Any insights would be much appreciated.

  1. SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [f:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SCCMS.mdf] in database [SCCMS] (11).

  2. A time-out occurred while waiting for buffer latch -- type 4, bp 036E9578, page 1:1616250, stat 0x2c0010f, database id: 11

  3. SQL Server has encountered 306 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [f:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SCCMS.mdf] in database [SCCMS] (11).

  4. Time out occurred while waiting for buffer latch -- type 2, bp 03758560, page 1:27814, stat 0x7c0040d, database id: 11

  5. Time out occurred while waiting for buffer latch -- type 2, bp 0375CD38, page 1:348668, stat 0x5c0040d, database id: 11

  Michael

• BuntyBoy

  SSCommitted

  Points: 1876

  More actions

  September 7, 2011 at 3:08 pm

  #1378288

  This is mainly a performance related issue at OS/harware level. try checking this link:-

  http://support.microsoft.com/kb/897284

  ===========================================
  Better try and fail than not to try at all...

  Database Best Practices[/url]

  SQL Server Best Practices[/url]