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 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2005-11-11 : 04:40:28
|
| Anyone encountered this log warning before?WARNING: EC 23af9550, 0 waited 300 sec. on latch 19e13e70. Not a BUF latch.what happened in your system? how did you resolve it?any idea/help greatly appreciated...--------------------keeping it simple... |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-11 : 09:16:07
|
| Friday again is it Jen? Got your sleeping bag with you?!Good luck!Kristen |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-12 : 22:01:16
|
When you get them, you get a whole flood of them Jen?  What service pack/patch level are you at?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-13 : 20:35:00
|
yeah, when it rains it pours, just had to come in over 3 holidays 2 weeks ago and now this during the weekend...sp3a, I was digging into the latch thing coz this scenario is related to the other post I did though I can say that it's an off-shoot, coz this warning only showed after 4 hours when the insert problem occuredodd note:i don't want to think i'm jinxed every weekend  there is a logical explanation to these things--------------------keeping it simple... |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-13 : 22:19:22
|
| Are you performing maintenance when this happens? Do you have SQL LiteSpeed? Are there any processes that get disturbed when this happens?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-13 : 22:29:21
|
| no maintenance tasks... --------------------keeping it simple... |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-14 : 01:11:04
|
| thanks EC, no i haven't read that KB article...the article is great and close to what occuredbut there might be more, keep 'em coming guys--------------------keeping it simple... |
|
|
|
|
|
|
latches or blocks?