Time-out occurred while waiting for buffer latch

• SQL.AP

  Hall of Fame

  Points: 3244

  More actions

  March 31, 2015 at 3:31 am

  #295622

  Hi Guys,

  I am getting below error while executing any SQL query on database server.

  Time-out occurred while waiting for buffer latch type 2 for page (20:17937), database ID 13.

  There is currently some space issue on the server, so by any chance this space issue is causing this error?

  Please help me.

  ____________________________________________________________

  AP

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  March 31, 2015 at 6:47 am

  #1787666

  What version of SQL are you running? I've seen a KB article which describes what you're seeing http://support.microsoft.com/en-us/kb/2545989

• Grant Fritchey

  SSC Guru

  Points: 398886

  More actions

  March 31, 2015 at 7:02 am

  #1787677

  You may just have a long running transaction. Check to see if that process is blocked by looking at sys.dm_exec_requests.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning