Skip navigation
Currently Being Moderated

WMI MSSQL

VERSION 9  Click to view document history
Created on: Dec 22, 2009 6:30 PM by Snake-BIS - Last Modified:  Sep 1, 2010 6:03 PM by Matt Ray

Submitted by: Richard Esteve


Description:

This WMI-based ZenPacks provides 3 templates for monitoring Microsoft SQL Server, depending on your version:

  • WMIPerfMSSQL2000
  • WMIPerfMSSQL2005
  • WMIPerfMSSQL2008

 

The new templates are available on the /Devices/Server/Windows device class and provides graphs for many MSSQL counters :

  • Disk IOPS
  • SQL User connections
  • Locks
  • SQL Transactions
  • FullTableScans
  • Cache Hit
  • ...

 

It works with only 1 MSSQL Instance per device (a zProperty named zSQLInstance is created during the ZenPack Installation).


Screenshots:

WMIPerfMSSQL.png

Clipboard165.jpg

Clipboard166.jpg

 


REQUIREMENTS:

  • Zenoss Version: 3.0
  • ZenPack Dependencies: WMI Data Source
  • External Dependencies:
  • Installation: Just install the ZenPack, restart Zenoss, apply the good template and fill in the zSQLInstance property.

Source: http://zenpacks.zenoss.org/trac-zenpacks/browser/zenpacks/ZenPacks.community.WMIPerf_MSSQL

Tagged Releases:

Change History:

  • 1.2 initial release
  • 1.4 now 3 templates for different versions of SQL Server
  • 1.4.1 :
    • Bug correction on the SQL2008 template
    • Optimisation on the SQL2000 template
    • Graph tunning on the SQL2005 template
  • 2.0.1 :
    • Zenoss 3.0.0 compatibility
    • Added thresholds for MSSQL2000

Trac tickets: http://zenpacks.zenoss.org/trac-zenpacks/report/1

Known issues:

  • Doesn't work with non-instance MSSQL Installation (needs new templates)
  • Doesn't work with 64bit MSSQL Installation (Microsoft WMI limitation)
Comments (61)