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


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:

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 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:

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