Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Displays the interval (in hours, minutes, and seconds) between times when the service collects diagnostic data and raises the associated alerts. Use a value between 30 seconds and 30 minutes. Lower values result in a faster-triggered alert , but also cause more frequent refreshes, which may increase monitoring overhead. You can modify this setting directly in this view. Click in the appropriate field, make your change, and then click Save Changes. For more information about this setting, see Set general server options.

...

Displays whether monitoring of non-query activities is enabled. The monitoring of non-query activities captures autogrow events, deadlocks, and blocks. For more information about this setting, see Set activity monitor options.

Baseline Date Range

Displays the period of time over which the server baseline is calculated. For more information about this setting, see Set server baseline options.

Baseline Time Period

Displays the date range over which the server baseline is calculated. For more information about this setting, see Set server baseline options.

Changed?

Displays an edit icon to indicate that this row includes a change from the last time the data was saved. Click Save Changes to retain any changes made in this view. Click Reset Changes to revert to the most-recently saved server configuration properties.

...

Displays the interval (in hours, minutes, and seconds) between times when the server availability is verified. Use a value between 30 seconds and 10 minutes. If a select 1 query cannot execute in this timeframe, then the server is considered unresponsive. Setting your server availability check to a very low value may result in false-positive alerts. You can modify this setting directly in this view. Click in the appropriate field, make your change, and then click Save Changes. For more information about this setting, see Set general server options.

...

Displays the interval (in hours, minutes, and seconds) between times when the database space-related data is collected and associated alerts are raised. Use a value between one minute and 24 hours. Setting your database statistics refresh to a low value may result in false-positive alerts. A low setting also causes refreshes to occur more often, which increases the monitoring overhead. In environments with a large number of databases whose sizes do not change rapidly, setting this refresh to a long interval can greatly reduce your monitoring footprint. You can modify this setting directly in this view. Click in the appropriate field, make your change, and then click Save Changes. For more information about this setting, see Set general server options.

...

Displays the current state of deadlock monitoring, which raises alerts for deadlocked sessions on your monitored SQL Server instance. Deadlock monitoring is supported on monitored servers running SQL Server 2005 or greater and is dependent on enabling the monitoring of non-query activities in the Activity Monitor window. For more information about this setting, see Set activity monitor options.

Disk Collection Settings

...

Displays whether job alerting is enabled, causing a specific job alerts alert collector to run. Job alerting is considered enabled if one of the following alerts is enabled:

...

Displays whether query monitoring is enabled. The Query Monitor collects poorly-performing queries such as SQL batches, statements, stored procedures, and triggers. Low thresholds for query monitoring may impact performance. For more information about this setting, see Set Query Monitor options.

Query Monitor Thresholds

Displays the various threshold types for query monitoring. Note that low thresholds for the query monitoring impacts performance. For more information about these settings, see Set Query Monitor options.

Query Waits

Displays the date and time when the query-level wait statistics are collected or whether they are collected indefinitely. By default, these statistics are available only when the Query Waits view is open. Collection of query waits is a performance-intensive operation. For more information about this setting, see Configure wait monitoring.

...

Displays whether extended session data collection is disabled, including collection of session details, locks, and blocks. Collection of this data allows you to view past session detail, lock, and block information , but incurs extra monitoring overhead to provide this data. This data also requires extra space in the SQLdm Repository. You can modify this setting directly in this view. Click in the appropriate field to make your change, and then click Save Changes. For more information about this setting, see Set general server options.

...