September 26, 2011 at 5:00 am
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
September 26, 2011 at 8:30 am
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/
September 26, 2011 at 8:46 am
mirjawad_2k (9/26/2011)
I received the below error while rebuilding indexes on the large table . Do you have any info about these errorsThe 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" 😉
September 26, 2011 at 9:54 am
tv1H:\tv.mdf
tv1_log2J:\SQLLOG\tv1.LDF
tv_Secondary3I:\tv_Secondary.ndf
September 26, 2011 at 9:58 am
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
September 26, 2011 at 10:17 am
RAID 5 /SAN disks/ allocation units i d'ont have idea how to check..
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply