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.
Author |
Topic |
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-04-28 : 10:40:13
|
MS SQL Server 2000 SP4Getting the following errors.. can anyone help? Sleeping until external dump process completes.Resuming after waiting on external debug process for 8 seconds.Stack Signature for the dump is 0x00000000Error: 17883, Severity: 1, State: 0Process 104:0 (fd4) UMS Context 0x0775B548 appears to be non-yielding on Scheduler 0.SQL Server has encountered 37 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [e:\Microsoft SQL Server\\webslog631_2.mdf] in database [webslog631_2] (35). The OS file handle is 0x0000071C. The offset of the latest long IO is: 0x0000007e6b8000 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 13:03:26
|
Does DBCC CHECKDB return errors? If it does, post the entire output in the Data Corruption forum here so that Paul can take a look.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-04-28 : 14:33:44
|
DBCC CHECKDB does not report any errors. Did some more digging and I suspect that the errors may have been caused by intermittent SAN problems that we HAD been having and may have resurfaced.. My boss is most concerned about the 'Sleeping' condition in this series of errors and wanted me to investigate whether there was a patch for it (we are on sp4). Anyone know where i can find anything that says these errors might be 'bad disk' related? I've been googling this till I'm crosseyed :) any help or thought appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 14:38:37
|
I'd open a case with Microsoft and let them know you are receiving this error in SP4 even though according to this article it is fixed in SP3:http://support.microsoft.com/kb/891268Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 14:39:28
|
Or perhaps check this one out: http://support.microsoft.com/kb/909734Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-04-28 : 15:05:55
|
Thank you!!!! How do I contact MS without giving them a Credit Card number??? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 15:09:57
|
It is free to call them if they find that your issue is due to their bug, otherwise it costs something like 250 bucks.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-04-29 : 16:09:28
|
Thanks for your help and support. Microsoft determined that our Server is a candidate for the hotfix mentioned in the second KB article.. Thanks again |
|
|
|
|
|