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

  • 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

  • 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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply