Number of Deadlocks/sec

Question

Number of Deadlocks/sec

Allen Cui-55137

SSC Guru

Points: 51650
More actions
November 15, 2002 at 9:58 am

#159198

Can someone explain the SQL Server performance counter 'Number of Deadlocks/sec' in SQLSErver:Locks when the current value is greater than 1.
What exactly this counter means?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

Number of Lock Requests per second that resulted in a deadlock. It should be zero. If it's not, then deadlocks are occuring.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 2

I have turned on the trace 1024 and 3605, If there are deadlocks occuring, the deadlock information should also be logged into the SQL Server errorlogs but I don't see them in the SQL Server errorlogs when the 'Number of Deadlocks/sec' is 6. Any ideas? Thanks.