Time-out occurred while waiting for buffer latch type 2 for page (1:7512231), database ID 8.

Question

Time-out occurred while waiting for buffer latch type 2 for page (1:7512231), database ID 8.

seven.srikanth

Ten Centuries

Points: 1212
More actions
January 2, 2012 at 12:28 am

#248376

Hi Guys,
Happy New Year.
Got the following error while rebuilding the index.
Time-out occurred while waiting for buffer latch type 2 for page (1:7512231), database ID 8.
Please help me. ASAP.

Viewing 7 posts - 1 through 6 (of 6 total)

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

Devendra Shirbad SSC-Forever Points: 42493 More actions · Answer 1

Latches are momentarily. If you run rebuild index you might not get it again. If you get this error frequently, you should concentrate on disk I/O.

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 2

What version and service pack level are you on? Is this a larger DB/Table? I had this problem and it can be very difficult to pinpoint what the issue is.

johnitech.itech Hall of Fame Points: 3252 More actions · Answer 3

johnitech.itech

Hall of Fame

Points: 3252

January 3, 2012 at 7:39 am

#1427733

:hehe:

OK you can check a good link below

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 4

from an SSMS query window. go to Query, Query Options, Execution. What is the value for Execution time-out?

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 5

obtain the latest service pack for Microsoft SQL Server version you installed

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 6

check out this link may be helps to solve your issue

http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3BQ310834