Versions Compared

Key

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

...

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 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 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 a 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.

...