Extended Monitoring Guide

  • Docs Home
  • Community Home
3. Enable MS SQL Server Monitoring
Prev Chapter 45. SQL Transactions Next

3. Enable MS 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. Navigate to the device in the Zenoss web interface.

  2. Click the page menu, then select More → Templates.

  3. Create a performance template by selecting Add Template from the page menu.

  4. Enter an identifier for the template and then click OK to create it.

  5. Click on the newly created template.

  6. Select Add DataSource... from the Data Sources table menu.

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

  8. The Data Source page appears.

    Change options as needed.

    Table 45.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. The default port is 1433.

    Database Name

    Specify the name of the database.

    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.


  9. Click Save to save your changes.

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

See the Administration Guide for more information about setting up thresholds and graphs.

Prev Up Next
2. Prerequisites Home 4. Enable Sybase Server Monitoring