Submitted by:
Fabio Paracchini
Updated by:
Andrew Margerison
Description:
This ZenPack is for monitoring MS SQL Server Performance, working and tested for SQL 2000 and SQL 2005.
You can graph the most significant counters for SQL Server, as:
- Cache Hit Ratio
- Transactions per second
- Locks requests per second
- Lock wait time
- Full table scans per second
Screenshots:
REQUIREMENTS:
Zenoss Version: 2.2
ZenPack Dependencies:
External Dependencies:
Installation:
User connections Installation is as follows (a bit tricky, since you have to add a new zProperty to support correctly multi-instance SQL):
- Install Perfmon ZenPack by Mark Gold
- Install the ZenPack (upload via Settings -> ZenPacks)
- Bind the template to /Devices/Windows or wherever you prefer - Have a valid windows user with administrator access in zWinUser and zWinPassword
Source: http://zenpacks.zenoss.org/trac-zenpacks/browser/zenpacks/ZenPacks.altea.SQLServer
Tagged Releases:
http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/sql-server-performance-1.1
Change History:
Trac tickets: http://zenpacks.zenoss.org/trac-zenpacks/report/1
Known issues: