TECHZEN Zenoss User Community ARCHIVE  

Performance metrics for MSSQL server 2008-2012

Subject: Performance metrics for MSSQL server 2008-2012
Author: Giovanni Parisi
Posted: 2016-05-02 02:54

Hello everyone,

I'musing Zenoss Core ver. 4.2.5 (on red-hat) and i'm tryning to implement performance counters for MSSQL (as locks metricsfor Windows server 2008-2012)

I could note that these metrics aren't present in zenpack microsoft.

I tried to implement these metrics, placing them in the group template to check the "database" (for exsample "\sqlserver:locks(_total)\lock requests/sec" as performance counter), but I can not make them work.

Please, can you help me how can implement these metrics

Thank you and

Best regards,

Giovanni



Subject: Were you able to figure out
Author: [Not Specified]
Posted: 2016-05-31 15:09

Were you able to figure out how to add custom SQL monitoring I'm looking to add performance counters, but have been unable to figure this out. Thanks.



Subject: How are you setting up your
Author: Jay Stanley
Posted: 2016-06-01 09:54

How are you setting up your datasource And what datasource type are you using



Subject: I've tried a few different
Author: [Not Specified]
Posted: 2016-06-01 11:12

I've tried a few different things here, but this is the one I thought would work.

The counter I'm trying to pull is "Lock Wait Time (ms)". I can get the data in powershell with "\\\:Locks(*)\Lock Wait Time (ms)", but I don't know how this translates into Zenoss.

< Previous
Need API or REST Call Command Example to Output osModel name Searching by IP
  Next
['SESSION_INVALID', 'OpaqueRef:da087690-16e6-65fa-9d93-19acb8e05c36'] while moni ...
>