ZenPack:MS SQL Server 64-bit SNMP

From Zenoss Wiki
This is the approved revision of this page, as well as being the most recent.
Jump to: navigation, search
Author(s)
John Field
Current Maintainer(s)
John Field
License
GNU General Public License, Version 2, or later
ZenPack name
ZenPacks.community.MSSQL64Monitor
More Information
GitHub page/HomePage
Link to more docs
View Documentation
Git sources (for cloning)
Link




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.

Warning

The ZenPack Catalog has moved to its new home at https://www.zenoss.com/product/zenpacks as of January 17, 2017. The following information may be out of date, and this page will eventually be removed.

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

Discuss

Purplemarker.png New: Don't forget to add yourself to the Zenoss User Map!

blog comments powered by Disqus