Ad Widget

Collapse

Setup calculated (SUM) created performance counters

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vega2511
    Junior Member
    • Mar 2014
    • 11

    #1

    Setup calculated (SUM) created performance counters

    Hello,

    I'm using zabbix2.2.x
    I want to calculate (sum) below standing performance counters.

    last(perf_counter["\SQLServeratabases(tempdb)\Data File(s) Size (KB)"])+
    last(perf_counter["\SQLServeratabases(tempdb)\Log File(s) Size (KB)"])

    I want to see the result total of tempdb en the next step is to create a trigger for that total.

    I've seen that you have to create a calculated item and then......

    False example:
    last(perf_counter["\SQLServeratabases(tempdb)\Data File(s) Size (KB)"])+
    last(perf_counter["\SQLServeratabases(tempdb)\Log File(s) Size (KB)"])

    Can someone show me some example?
  • steveboyson
    Senior Member
    • Jul 2013
    • 582

    #2
    You may want to try to append the "last" function, e.g.
    Code:
    {item_1.last(0)} + {item2.last(0)}
    Perhaps that could work.

    Comment

    • vega2511
      Junior Member
      • Mar 2014
      • 11

      #3
      Hi,

      no I've tried your code but unfortunately it didn't work.

      name: tempDB_Calc
      Type: Calculated
      Key: SQLServer_SUM_tempdb_DEV
      Formula: {tempdb_Data.last(0)} + {tempdb_Log.last(0)}
      Type of information and Units and use Custom multiplier are the same as the created item keys:
      tempdb_Data
      tempdb_Log from witch i receive results.

      example of tempdb:
      perf_counter["\SQLServeratabases(tempdb)\Data File(s) Size (KB)"]

      Do you have another option?

      Comment

      • steveboyson
        Senior Member
        • Jul 2013
        • 582

        #4
        Calculated items operate always with item keys, not names.
        Try to add the item keys. By the way, where do the backslashes come from?

        If that all does not work, you may try to use an external script and hook that in via a userparameter. Or let that script just return the value, this will eliminate the somewhat weird item keys.

        Comment

        Working...