Number of Deadlocks/sec

Question

Number of Deadlocks/sec

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

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

K. Brian Kelley SSC Guru Points: 114704 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.