Rebuild index -Timeout error

Question

Post reply

Rebuild index -Timeout error

mirjawad_2k

SSC Enthusiast

Points: 199
More actions
September 26, 2011 at 5:00 am

#257910

I received the below error while rebuilding indexes on the large table . Do you have any info about these errors
The server is a 64bit OS and has 32Gb memory and sufficient hard disk spaces
Msg 845, Sev 17, State 1, Line 1 : Time-out occurred while waiting for buffer latch type 3 for page (1:75662342), database ID 7. [SQLSTATE 42000]
Msg 3621, Sev 17, State 1, Line 1 : The statement has been terminated. [SQLSTATE 01000]
Regards
Mir

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

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

Sean Lange SSC Guru Points: 286602 More actions · Answer 1

Here is a thread on this site on the very topic.

http://www.sqlservercentral.com/Forums/Topic305986-92-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Perry Whittle SSC Guru Points: 234040 More actions · Answer 2

mirjawad_2k (9/26/2011)
I received the below error while rebuilding indexes on the large table . Do you have any info about these errors
The server is a 64bit OS and has 32Gb memory and sufficient hard disk spaces
Msg 845, Sev 17, State 1, Line 1 : Time-out occurred while waiting for buffer latch type 3 for page (1:75662342), database ID 7. [SQLSTATE 42000]
Msg 3621, Sev 17, State 1, Line 1 : The statement has been terminated. [SQLSTATE 01000]
Regards
Mir

can you supply details of file layouts for database id 7 and the drives themselves?

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

"Ya can't make an omelette without breaking just a few eggs"

mirjawad_2k SSC Enthusiast Points: 199 More actions · Answer 3

tv1H:\tv.mdf

tv1_log2J:\SQLLOG\tv1.LDF

tv_Secondary3I:\tv_Secondary.ndf

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

What is the raid level on your drive? How many spindles? Is it SAN or Direct attached? What is the allocation unit size (8k, 64k other)?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

mirjawad_2k SSC Enthusiast Points: 199 More actions · Answer 5

RAID 5 /SAN disks/ allocation units i d'ont have idea how to check..

Rebuild index -Timeout error

Cookies on SQLServerCentral