SQL Server Performance Forum – Threads Archive

buffer latch error

I recently took a 40GB database, with all data on the primary filegroup, and moved all the non-system tables/indexes to their own filegroups. As I moved the files from the primary filegroup I used dbcc shrinkfile to reduce the file size. The file is now down to 5GB, with roughly 125mb used, and I get the following error: Server: Msg 845, Level 17, State 1, Line 1
Time-out occurred while waiting for buffer latch type 4 for page (1:694913), database ID 8. Due to this error I cannot reduce the file size below 5GB’s. I’ve seen some similar information on this error but not this specific case.

http://support.microsoft.com/default.aspx?scid=kb;en-US;310834 – common causes and to resolve. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks Satya, I’ve seen that article but it didn’t help me with this problem. I’ve checked most of the settings in that article and none apply to this situation. I’ve even restored the database to anothere server and still get the error on the restored db.

WHat is the level of service pack on SQL & OS?
Also check thru event viewer for any h/w issues. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

SP3 on both OS and SQL. No hardware issues are present.

There are many reasons why you could possibly be getting the 845 error and the problem with AWE was just one possibility, As referred in the above KBA. I’m also leaning towards this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;309093 as an alternative. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>