Page History
...
You can access the Maintenance Mode function by right-clicking the appropriate monitored SQL Server instance, and then selecting Maintenance Mode. This will prompt three command options: Enable, Disable, and Schedule.
The Enable command puts the SQL Server instance into maintenance mode, stopping alert generation and collection of some performance metrics.
The Disable command allows SQL Diagnostic Manager to resume performance statistics collection and alert generation for the selected SQL Server instance.
The Schedule... command prompts the monitored SQL Server Properties dialog, where under the Maintenance Mode tab it is possible to select a specific maintenance mode setting.
Tip |
---|
A different way to access the Maintenance Mode function is by right-clicking the monitored SQL Server instance , and then selecting Properties. Click Maintenance Mode when SQL Diagnostic Manager displays the Monitored SQL Server Properties window. |
...
Available maintenance mode settings
...
You can choose from the following options when setting a monitored SQL Server instance to maintenance mode:
Never
The server is never in maintenance mode and always generates alerts.
Until further notice
The server is in maintenance mode and does not generate alerts until this setting is changed.
Recurring every week at the specified time
Set the server to enter maintenance mode at regular intervals, for the day, time, and duration you select.
Recurring every month at the specified time
Set the server to enter maintenance mode at regular intervals, for the month, time, and duration you select.
Occurring once at the specified time
The server enters maintenance mode at a specified date and time , and leaves maintenance mode at a specified date and time.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...