Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Buffer Latch type 3 Errors

Author  Topic 

poser
Posting Yak Master

124 Posts

Posted - 2011-12-06 : 19:12:20
I have a SSIS package that just started failing and these errors are just now showing up in SQL logs:

'Time-out occurred while waiting fro buffer latch type 3 for page (10:286936) Database ID 19
Error: 845, Severity: 17, State: 1.
A time-out occured while waiting for buffer latch - type 3, bp 00000002A7FD1180, page 10:286936, stat 0x5d0000f, database id: 19, allocation unit id: 72057601366032384, task 0x0000000003A26478: 0, waittime 300, flags 0x39, owning task 0x0000000003A3A868. Not continuing to wait.

Any ideas on why this is just starting?
Thanks for any help,
r/p

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-06 : 19:20:31
http://sqlserverpedia.com/wiki/Latches_-_Buffer_Latch_Timeout_Errors

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

poser
Posting Yak Master

124 Posts

Posted - 2011-12-06 : 19:29:51
Thanks Tara....
I'm running SQL 2005 64bit on windows 2003

I have seen a lot referring to SQL 2000 but not much for 2005....
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-06 : 19:58:14
The basic information still applies. You've got a hardware resource issue.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

poser
Posting Yak Master

124 Posts

Posted - 2011-12-06 : 20:59:37
Thanks, I will look into some of their resolutions...
Wish me luck!
r/p
Go to Top of Page
   

- Advertisement -