September 1, 2011 at 4:42 am
Hi,
DATE/TIME:9/1/2011 4:07:13 PM
DESCRIPTION:The SQL Server performance counter 'Lock Wait Time (ms)' (instance '_Total') of object 'SQLServer:Locks' is now above the threshold of 30.00 (the current value is 1117.15).
COMMENT:(None)
JOB RUN:(None)
I have receive mail alert from server,
I checked sp_who2, but there is no any blocking transaction. Next step what should I do?
Thanks
September 1, 2011 at 9:03 am
I guess this comes from some kind of monitoring tool?
Most tools attempt to set a threshold , locks is not an easy one to set, for instance I see my main prod server is showing over 900k lock requests/sec
I'm guessing this is an alert you can ignore - or get the monitoring team to disable.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
September 1, 2011 at 9:06 am
have a read up on this info from SQL Cat team ( on my website )
http://www.grumpyolddba.co.uk/monitoring/Performance%20Counter%20Guidance%20-%20SQL%20Server.htm
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply