Ad Widget

Collapse

A metric that should be reporting as a whole number

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tchjts1
    Senior Member
    • May 2008
    • 1605

    #1

    A metric that should be reporting as a whole number

    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:

    Code:
    perf_counter["\MSSQL$hostname:Locks(_Total)\Number of Deadlocks/sec",60]
    And then what we are currently seeing and the item config:
    Attached Files
  • LenR
    Senior Member
    • Sep 2009
    • 1005

    #2
    Does this item update every 30 seconds?

    If you had 6 deadlocks in the last update interval, then the value would be 6/30 or .2

    Comment

    • tchjts1
      Senior Member
      • May 2008
      • 1605

      #3
      Good point. No, I have this item updating every 60 seconds.

      Comment

      Working...