Time-out occurred while waiting for buffer latch type 2 for page

• zayousafi

  SSC Veteran

  Points: 237

  More actions

  April 13, 2009 at 2:31 am

  #130560

  Hi, I am facing a strange exception from SqlServer. All the DML queries work fine and provides result normally. But when i try to get the schema of my DB either through Microsoft SQlserver Management Studio or by executing Information_Schema.Tables Query, I am getting following exception

  Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  Time-out occurred while waiting for buffer latch type 2 for page (1:68), database ID 18. (Microsoft SQL Server, Error: 845)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=845&LinkId=20476

  all other DBs on the same server works fine. Any Idea what is happening and how can I fix this problem

• seven.srikanth

  Ten Centuries

  Points: 1212

  More actions

  January 28, 2012 at 3:33 am

  #1439661

  Try adding one more data file to the database in to a new disk where you have got good amount of place.

  We got the same error and the above work around fixed it.