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:
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:
- http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/wmi-mssql-1.2
- http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/wmi-mssql-1.4
- http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/wmi-mssql-1.4.1
- http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/wmi-mssql-2.0.1
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)