Using the Monitoring Setup dialog box

The Monitoring Setup dialog box enables you to control whether or not PATROL monitors the SQL Server Agent, Filegroups and Files, Mirrors, and Replication. Monitoring for all of these features is turned on by default.
The Monitoring Setup dialog box also enables you to enable the monitoring of these SQL Server features.

Note

  • The SQL-Server-Agent-Failed-Jobs-SQLAgentJobFailure parameter does not display unless SQL Server Agent monitoring is enabled (turned on) in this dialog box.
  • The Filegroup and File application class instances do not display unless Filegroup and File space monitoring is enabled (turned on) in this dialog box.
  • The Subscriber and Published application class instances do not display unless replication monitoring is enabled (turned on) in this dialog box.
  • The SQL Server error log and SQL Server Agent error log
Warning

Enabling file and file group monitoring creates two to three instances for every file in your environment. For this reason, we do not recommend that you enable the monitoring of files and file groups if you have more than 100 databases or more than 200 files in your environment.

To use the Monitoring Setup dialog box:

  1. In the SQL Server Agent monitoring field:
    Click On to enable the monitoring of the SQL Server Agent.
    Click Off to disable the monitoring of the SQL Server Agent. (Off is selected by default.)
  2. In the Filegroup and File space monitoring field:
    Click On to enable the monitoring of file groups and files.
    Click Off to disable the monitoring of file groups and files. (Off is selected by default.)
  3. In the Replication monitoring field:
    Click On to enable the monitoring of replication.
    Click Off to disable the monitoring of replication. (Off is selected by default.)
  4. In the Database Mirroring Monitoring field:
    Click On to enable mirror monitoring.
    Click Off to disable mirror monitoring. (Off is selected by default.)
  5. In the Monitor SQL Server Error log field, click the checkbox to deselect or disable monitoring. (The checkbox is selected to enable monitoring by default.)
  6. In the Monitor SQL Server Agent Error log field, click the checkbox to deselect or disable monitoring. (The checkbox is selected to enable monitoring by default.)
  7. Click Apply.

Note

Changes made to the monitoring of files and file groups do not take effect until the DbStructureColl and DbSpaceColl collector parameters complete a polling cycle.

Changes made to the monitoring of replication do not take effect until the ReplicationColl collector parameter completes a polling cycle.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*