SQL 2000/2005 Server Performance

Submitted By: Fabio Paracchini

This ZenPack is for monitoring SQL Server Performance, working and tested for SQL 2000 and SQL 2005. It requires the very nice Perfmon ZenPack by Mark Gold, which queries Windows machines via winexe.

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

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 ZenPack (extract .egg from ZIP and upload via Settings -> ZenPacks)
• Add a property called "zSQLInstance" via Zope interface, using /zport/dmd/Devices/Server/Windows/manage, go to "Properties" and add "zSQLInstance," with default "SQLSERVER"
• Bind the template to /Devices/Windows or wherever you prefer - Have a valid windows user with administrator access in zWinUser and zWinPassword

File Name	Zenoss Dependency	Linux Distro
SQL Server Performance 1.0	2.2 (with Perfmon ZenPack)	n/a

[return: ZenPack Project Site]