Skip navigation
Currently Being Moderated

MS SQL 2000/2005 Server Performance

VERSION 4  Click to view document history
Created on: Sep 14, 2009 1:31 PM by fparacchini - Last Modified:  Nov 10, 2009 10:34 AM by Matt Ray

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





     Zenoss Version: 2.2

     ZenPack Dependencies:

Perfmon ZenPack

     External Dependencies:


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



Tagged Releases:

Change History:


Trac tickets:

Known issues:

Note: binary attachments ending in .zip will need to be unzipped before use.
Comments (1)