March 2, 2004 at 6:55 am
WARNING: EC 5db7b558, 0 waited 900 sec. on latch 42d7cd38. Not a BUF latch.
Waiting for type 0x3, current count 0xa, current owning EC 0x2138E098.
If anyone could assist in interpreting thess messages ... The user database is about 100GB now, running on SQL2000 SP3, with 3GB RAM and 4 processors. The user runs heavy i/o at night to calculate recursive options data. The error log shows a lot of these, but BOL is not particularly helpful because I don't know how to interpret waittype, waittime, lastwaittype, waitresource values in sysprocesses.
Regards, Melissa
March 2, 2004 at 12:01 pm
You can take a look at this article:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3BQ310834
and this one has info on deciphering waittypes:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;822101
Regards,
Steve
Meddle not in the affairs of dragons, for you are crunchy and taste good with ketchup.
March 2, 2004 at 1:28 pm
Thanks. The articles are helpful. None of the options are set, and the hardware is in good shape, so it must be the autogrow (autoshrink was set off long ago). User added 30GB of data over the weekend (don't ask), so that would explain the rash of warnings as the increment (10%) was hit several times.
Regards, Melissa
October 18, 2004 at 2:19 pm
Since the waittype was Share (0x3) then while adding 30GB worth of data there was quite a bit of lookup operations.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply