Maintenance mode allows you to temporarily stop alert generation and performance metric collection for the time period that your SQL Server instance is offline. This pause allows you to perform necessary maintenance on a SQL Server without causing SQLdm to send numerous misleading alerts.

Access the Maintenance Mode tab

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

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 SQLdm displays the Monitored SQL Server Properties window.

About mass maintenance mode

Users looking to apply maintenance mode modifications to a large number of servers at once can run the Maintenance Mode command by right-clicking on the following: Server Tree, a specific tag, a particular server view and Tools.

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 > >
  • No labels