Difference between revisions of "ZenPack:MS SQL Database Monitor"

From Zenoss Wiki
Jump to: navigation, search
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
 
{{ZenPack
 
{{ZenPack
|Summary=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.
+
|Summary=This ZenPack provides monitoring of MS SQL databases.
 
|Author=Egor Puzanov
 
|Author=Egor Puzanov
 
|Maintainer=Egor Puzanov
 
|Maintainer=Egor Puzanov
|Organization=
 
 
|ZenPack name=ZenPacks.community.MsSQLMon
 
|ZenPack name=ZenPacks.community.MsSQLMon
 
|Homepage=http://community.zenoss.org/docs/DOC-3391
 
|Homepage=http://community.zenoss.org/docs/DOC-3391
 
|Documentation URL=http://community.zenoss.org/docs/DOC-3391
 
|Documentation URL=http://community.zenoss.org/docs/DOC-3391
|Source URI=gits://github.com/epuzanov/ZenPacks.community.MsSQLMon.git
+
|Source URI=git://github.com/epuzanov/ZenPacks.community.MsSQLMon.git
 +
|Releases={{Release
 +
|Version=3.3
 +
|Tag=mssqlmon-3.3
 +
|Summary=fix sysperfinfo query and modeler plugin
 +
|Compatible with=Zenoss Core 2.5.x, Zenoss Core 3.2.x
 +
|Requires=RDBMS Monitoring, SQL Data Source,
 +
}}{{Release
 +
|Version=3.2
 +
|Tag=mssqlmon-3.2
 +
|Summary=switch from ODBC data source to SQL data source
 +
|Compatible with=Zenoss Core 2.5.x, Zenoss Core 3.2.x
 +
|Requires=RDBMS Monitoring, SQL Data Source,
 +
}}{{Release
 +
|Version=3.1
 +
|Tag=mssql-odbc-3.1
 +
|Summary=zMsSqlConnectionString (UID, PWD and SERVER options) overrides zWinUser, zWinPassword and manageIp values by modeling
 +
|Compatible with=Zenoss Core 2.5.x, Zenoss Core 3.2.x
 +
|Requires=RDBMS Monitoring, SQL Data Source,
 
}}
 
}}
http://community.zenoss.org/docs/DOC-3391
+
|Devices=
 
+
|Applications={{Application
{{DISQUS}}
+
|Product Name=MS SQL
 +
|Version=Multiple
 +
}}
 +
|Binaries=
 +
}}
 +
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.
 +
{{ZenPackFooter}}

Latest revision as of 17:04, 10 November 2012

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