July 18, 2014 at 3:03 am
Today I have received lots of error in the sql error logs. Please help me to troubleshoot them.
A time-out occurred while waiting for buffer latch -- type 3, bp 000000042DFE7E80, page
1:22723400, stat 0xc0000b, database id: 7, allocation unit Id: 72057595033288704, task
0x0000000005E1C748 : 0, waittime 300, flags 0x100000001a, owning task 0x0000000005E094C8.
Not continuing to wait.
-------------------------------------------------------------------
Error: 845, Severity: 17, State: 1.
Message
Timeout waiting for external dump process 15804.
-------------------------------------------
Timeout occurred while waiting for latch: class 'LOG_MANAGER', id 00000000059A0AE0, type
4, Task 0x0000000005E1C988 : 0, waittime 300, flags 0x1a, owning task 0x0000000005E094C8.
Continuing to wait.
----------------------
* Short Stack Dump
* Latch timeout
* BEGIN STACK DUMP:
Please help me to check what exactly it is related to.
July 18, 2014 at 4:28 am
You may want to call Microsoft Customer Support and open a case.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 18, 2014 at 5:09 am
Should I run DBCC Checkdb before that?
This database is used for BI purpose.
July 18, 2014 at 9:15 am
You should be running CheckDB regularly anyway.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply