ZenPacks

MS SQL Server 64-bit SNMP ZenPack

This ZenPack provides performance monitoring/graphing for 64-bit MS SQL Servers. This ZenPack requires snmp-informant-SQLv2 to be installed on the monitored host.

Support

This ZenPack is developed by the Zenoss user community and supported via our online forums. Zenoss, Inc. does not provide direct support for this ZenPack.

Releases

Version 1.0- Download
Compatible with Zenoss Core 2.5.x, Zenoss Core 3.1.x, Zenoss Core 3.2.x

Background

Monitoring and graphing includes -

  • Number of temporary tables/table variables in use
  • Number of logical connections to the system
  • Total number of logins started per second
  • Total number of logouts started per second
  • Number of currently blocked processes
  • Number of SOAP SQL requests started per second
  • Number of SOAP Web Service Description Language requests started per second
  • Number of temporary tables/table variables created/sec
  • Number of transaction enlistments
  • Number of users connected to the system

No thresholds have been defined, that should be completed by the end user.

Installation

Normal Installation (packaged egg)

  1. Download the appropriate egg file for the version of Zenoss you are running.
  2. Ensure you are logged in as the zenoss user:
    $ sudo su - zenoss
  3. Install the ZenPack:
    $ zenpack --install ZenPacks.community.MSSQL64Monitor-*.egg
  4. Restart these services:
    $ zenoss restart

Developer Mode Installation

In order to do a development mode installation you will want to clone the existing git repository, and then use the --link flag with the zenpack command:

  1. Ensure you are logged in as the zenoss user:
    $ sudo su - zenoss
  2. Start by cloning the upstream repository:
    $ git clone git://github.com/zenoss/ZenPacks.community.MSSQL64Monitor.git
  3. Next, perform the installation:
    $ zenpack --link --install ZenPacks.community.MSSQL64Monitor
  4. Finally, restart these serivices:
    $ zenoss restart

Community

This ZenPack is developed and supported by the Zenoss User Community. Contact Zenoss to request more information regarding this or any other ZenPacks. Click here to view all available Zenoss Community ZenPacks.