Use the Server Overview Defaults window to configure when you want SQL Doctor to warn you about the health status of your servers.

You can set the maximum threshold values for several crucial server properties and statistics. SQL Doctor applies these thresholds to all SQL Server instances in your environment, and assesses the real-time health of each server accordingly.

To see the current health of a particular server, routinely check its Server Overview.

Access the Server Overview Defaults window

You can access the Server Overview Defaults window by clicking Edit > Server Overview Defaults.

Use the Server Overview Defaults window settings

Most Recent Analysis

Triggers a warning if there is no analysis performed in the entered number of days.

Recommendations

Triggers a warning if the number of recommendations in the most recent analysis exceeds the entered number of recommendations.

Priority

Triggers a warning if the recommendation priority meets or exceeds the selected level.

CPU Usage

Triggers a warning if the CPU usage exceeds the entered percentage.

Memory Available

Triggers a warning if the memory available dips below the entered amount in megabytes (MB).

Blocking Processes

Triggers a warning if the number of blocking processes (by SPID) exceeds the entered amount.

Network Retransmits

Triggers a warning if the network retransmits exceeds the entered percentage.

Disk Space

Triggers a warning if the free space available on the disk dips below the entered percentage.

Recent Full Backups

Triggers a warning if there is no full backup performed in the entered number of days.

Recent Log Backups

Triggers a warning if there is no log backup performed in the entered number of days.

Failed Jobs

Triggers a warning if any job fails in the entered number of past hours.


SQL Doctor provides complete SQL performance tuning. Learn more > >