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.
- 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)
- Download the appropriate egg file for the version of Zenoss you are running.
- Ensure you are logged in as the zenoss user:
$ sudo su - zenoss
- Install the ZenPack:
$ zenpack --install ZenPacks.community.MSSQL64Monitor-*.egg
- 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:
- Ensure you are logged in as the zenoss user:
$ sudo su - zenoss
- Start by cloning the upstream repository:
$ git clone git://github.com/zenoss/ZenPacks.community.MSSQL64Monitor.git
- Next, perform the installation:
$ zenpack --link --install ZenPacks.community.MSSQL64Monitor
- Finally, restart these serivices:
$ zenoss restart
Discuss
New: Don't forget to add yourself to the Zenoss User Map!