The Monitored SQL Server Properties window allows you to edit the SQL Diagnostic Manager monitoring settings for the registered SQL Server instance. To access the Monitored SQL Server Properties window, right-click a SQL Server instance from the Server tree and select Properties.

The Monitored SQL Server Properties window includes the following tabs:

General

The General tab displays common properties such as the data collection interval, credentials, and encryption options.

Baseline Configuration

The Baseline Configuration option allows you to set the date range and time used to calculate a performance baseline for the monitored SQL Server instance.

Query Monitor

Allows you to enable or disable query monitoring, and set the options for Query Monitor.

Activity Monitor

Allows you to enable or disable monitoring of non-query activities, and set the options for Activity Monitor.

Replication

The Replication tab lets you disable replication statistics collection to conserve system resources.

Table Statistics

The Table Statistics tab allows you to select the time and days SQL Diagnostic Manager collects table statistics on your SQL Server instance. In addition, you can select the minimum size table needed for SQL Diagnostic Manager to rebuild the index.

Custom Counters

Allows you to link custom counters to the monitored SQL Server instance.  

Maintenance Mode

The Maintenance Mode tab allows you to enter the maintenance schedule for your server. This allows you to turn off alerts and notifications for the time periods when you know the server is unavailable.

OS Metrics

The OS Metrics tab allows you to select how you want your operating system data collected, whether through OLE automation or direct WMI. You can also choose to not collect OS data.

Disk Drives

The Disk Drives tab allows SQL Diagnostic Manager to alert on disk drives and database space calculations for the monitored SQL Server instance.

Cluster Settings

The Cluster Settings lets SQL Diagnostic Manager trigger an alert whenever a cluster is running on a non-preferred node within a clustered environment.

Wait Monitoring

The Wait Monitoring allows you to collect and view wait statistics in the hopes of diagnosing any bottleneck on your system.

Virtualization

The Virtualization displays the name of the host server on which the selected monitored SQL Server instance is running.

Analysis Configuration

Allows you to schedule a prescriptive analysis of your monitored SQL Server instance. For more information, visit Configure prescriptive analysis options.

Copy Settings

Copy Settings allows you to copy and use your server configuration in a new or different server.

IDERA ProductsPurchase | Support | Community | Resources | About Us | Legal