We are measuring an MSSQL metric that should be reporting as a whole number, but is reporting as a decimal fraction. The number of deadlocks per second should be 0, 1, 2, 3 etc.
What am I missing here? I don't think I should be using a multiplier to fix this.
Here is the information:
The perf counter being used:
And then what we are currently seeing and the item config:
What am I missing here? I don't think I should be using a multiplier to fix this.
Here is the information:
The perf counter being used:
Code:
perf_counter["\MSSQL$hostname:Locks(_Total)\Number of Deadlocks/sec",60]
Comment