Can DBLocks cause problems?

We have a monitoring service that reported an alert last night at 12:17. It
reports based on the counter used in Perf Mon. This alert was based on
Locks-- Lock Wait Time(MS). Anyways, 7 minutes later my 5 Web Servers which
are load balanced were unable to connect to the DB and reported an error. A
few minutes later the sites recovered and the lock issue was resolved. Im
not able to tell which of these two things occured first though. Also around
this time I got an error in the SQL Error Log:
Error: 17883, Severity: 1, State: 0
2005-08-09 00:21:06.02 server The Scheduler 3 appears to be hung. SPID 4,
ECID 0, UMS Context 0x04A13268.
I read up on this but it doesnt say that it has anything to do with locks.
http://support.microsoft.com/default.aspx?kbid=810885
Any way I can figure out if the two are related? Any way to figure out why I
had long wait times on locks?
TIA, ChrisR
My guess would be the symptoms were as the result of the error you posted.
I would go by the KB and seeif you can address the issues that caused that
error and resolve it.
Andrew J. Kelly SQL MVP
"ChrisR" <noemail@.bla.com> wrote in message
news:ejLY9sQnFHA.2852@.TK2MSFTNGP15.phx.gbl...
> We have a monitoring service that reported an alert last night at 12:17.
> It
> reports based on the counter used in Perf Mon. This alert was based on
> Locks-- Lock Wait Time(MS). Anyways, 7 minutes later my 5 Web Servers
> which
> are load balanced were unable to connect to the DB and reported an error.
> A
> few minutes later the sites recovered and the lock issue was resolved. Im
> not able to tell which of these two things occured first though. Also
> around
> this time I got an error in the SQL Error Log:
> Error: 17883, Severity: 1, State: 0
> 2005-08-09 00:21:06.02 server The Scheduler 3 appears to be hung. SPID
> 4,
> ECID 0, UMS Context 0x04A13268.
> I read up on this but it doesnt say that it has anything to do with locks.
> http://support.microsoft.com/default.aspx?kbid=810885
> Any way I can figure out if the two are related? Any way to figure out why
> I had long wait times on locks?
> TIA, ChrisR
>