May 20, 2008 at 5:14 am
Hello,
I must known the number of deadlocks on my sql server, i've found that there's a column number of deadlocks/ sec in the sysperfinfo table, but how does that works?
I've generated a deadlock on my system and the counter increases from 1 to 2, but an hour later (and without any deadlock) the counter is not decreased back to one.
I don't understand why the description says deadlocks / seconds, but it's not measured over a 1 second period?
Are this columns mislabled and they only increase, and if I will take the number / deadlocks over an hour I need to minus the current value with the previous value in this column?
May 20, 2008 at 5:40 am
Some counters in sysperfinfo are monotonically increasing values. So they are no reset.
See http://support.microsoft.com/kb/555064
You can also downlad a script from SQL Magazine which helps intepreting sysperfinfo
http://www.sqlmag.com/Articles/ArticleID/26950/26950.html?Ad=1
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply