Archived community.zenoss.org | full text search
Skip navigation
Currently Being Moderated

54.3 Enable SQL Server Monitoring

VERSION 3  Click to view document history
Created on: Aug 16, 2011 11:31 AM by Zenoss API - Last Modified:  Aug 16, 2011 11:44 AM by Zenoss API

 3. Enable SQL Server Monitoring

Ensure that your Microsoft SQL Server authentication mode is set to "SQL Server and Windows Authentication mode." For more information about this setting and how to change it, refer to:

http://msdn.microsoft.com/en-us/library/ms188670.aspx

  1. Click the device in the device list.

  2. Select Device under Monitoring Templates in the left panel.

  3. Select Add Local Template from the Action menu.

    The Add Local Template dialog appears.

  4. Enter a name of the template, and then click Submit.

  5. Click the newly created template in the left panel.

  6. In the Data Sources area, click .

  7. Enter a name for the data source, select SQL as the type, and then click Submit.

  8. Double-click the newly created data source.

    The Edit Data Source dialog appears.

  9. Change options as needed.

     

    Table 54.2. MS SQL Server Transactions Data Source Options

    OptionDescription

    Database Type

    Enter MS SQL

    Host Name

    Set the host name on which the database is located. This field accepts a TALES expression, such as ${here/id} or ${here/getManageIp}

    Port

    Set the port on which the database server is listening. If you do not specify a port number, then the default port for the database is used.

    Database Name

    Specify the name of the database (required).

    User

    Specify a user name with permission to connect to the database and run queries.

    Password

    Specify the user password.

    SQL Queries

    Specify the SQL queries that this data source should execute. A summary of MS SQL syntax is available in the documentation accompanying the software.


  10. Click Save to save your changes.

     Resource Manager creates a data point that corresponds to the total query time in milliseconds.

  11. Click Test to verify that the database connection can be completed, and that the data returned from the queries are correct.

See the Administration Guide for more information about setting up thresholds and graphs. To create data points that store the results of queries, see the section titled "Data Points."

Comments (0)