Submitted by:

Fabio Paracchini

Updated by:

Andrew Margerison

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:

Perfmon ZenPack

     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 <span>Perfmon ZenPack</span> 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: