Page History
...
When you select the Server Configuration Properties view, SQL Diagnostic Manager displays a grid containing each of the settings for all of your monitored SQL Server instances. This information is updated each time the SQLdm Collection Service runs. Some cells allow you to make changes on this view while others are managed in other areas in SQL Diagnostic Manager, which are accessible by double-clicking the cell you want to change. SQL Diagnostic Manager displays the Change icon in the Changed? column for the row in which you made the change. Make sure you click Save Changes once you made the necessary change. Click Reset Changes to revert all unsaved changes you made on this view. The Change icon helps remind you to save your changes as shown in the following image.
The Server Configuration Properties view contains the following properties:
...
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.
...
Displays the name of the virtual machine on which this monitored SQL Server instance is running. This field applies only to SQL Server instances running on a virtual machine. For more information about virtualization configuration, see Configure virtualization.
| Scroll pdf ignore |
|---|
...