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 |
|
Dhudson29
Starting Member
23 Posts |
 Posted - 2014-10-03 : 11:32:27
|
| I keep getting an alert from a Third-Party Tool stating my server is reporting failed components with the following messageComponents Reporting Problems:Average Lock Wait Time(ms)(Critical)When I look at sp_who2 or sp_lock I don't see anything blocking processes or anything else out of the ordinary. Then again, I may not know what I'm looking for. Since I'm still fairly new, any ideas on this??? |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-03 : 11:42:08
|
| Probably the lock was released by the time you went to look |
 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
|
|
|
|
|
Average Lock Wait Time