ZenPack:MS SQL Database Monitor

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


Applications Monitored: 



MS SQL Database Monitor ZenPack

This ZenPack provides monitoring of MS SQL databases.

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 3.3- Download
Summary of changes: fix sysperfinfo query and modeler plugin
Requires RDBMS Monitoring ZenPack,SQL Data Source ZenPack
Compatible with Zenoss Core 2.5.x, Zenoss Core 3.2.x
Version 3.2- Download
Summary of changes: switch from ODBC data source to SQL data source
Requires RDBMS Monitoring ZenPack,SQL Data Source ZenPack
Compatible with Zenoss Core 2.5.x, Zenoss Core 3.2.x
Version 3.1- Download
Summary of changes: zMsSqlConnectionString (UID, PWD and SERVER options) overrides zWinUser, zWinPassword and manageIp values by modeling
Requires RDBMS Monitoring ZenPack,SQL Data Source ZenPack
Compatible with Zenoss Core 2.5.x, Zenoss Core 3.2.x

Background

This ZenPack provides monitoring of MS SQL databases. There are MsSqlDatabase and MsSqlSrvInst database component templates and a community.sql.MsSqlDatabaseMap zCollectorPlugin that the device will need to use. Use zMsSqlSrvInstances zProperty to specify list of MS SQL Server Instances.

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.MsSQLMon-*.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/epuzanov/ZenPacks.community.MsSQLMon.git
  3. Next, perform the installation:
    $ zenpack --link --install ZenPacks.community.MsSQLMon
  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