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.
You can access the Server Overview Defaults window by clicking Edit > Server Overview Defaults.
Triggers a warning if there is no analysis performed in the entered number of days.
Triggers a warning if the number of recommendations in the most recent analysis exceeds the entered number of recommendations.
Triggers a warning if the recommendation priority meets or exceeds the selected level.
Triggers a warning if the CPU usage exceeds the entered percentage.
Triggers a warning if the memory available dips below the entered amount in megabytes (MB).
Triggers a warning if the number of blocking processes (by SPID) exceeds the entered amount.
Triggers a warning if the network retransmits exceeds the entered percentage.
Triggers a warning if the free space available on the disk dips below the entered percentage.
Triggers a warning if there is no full backup performed in the entered number of days.
Triggers a warning if there is no log backup performed in the entered number of days.
Triggers a warning if any job fails in the entered number of past hours.
SQL Doctor provides complete SQL performance tuning. Learn more > >
|