Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Image AddedImage Removed

You can choose from the following options when setting a monitored SQL Server instance to maintenance mode:

...

The server enters maintenance mode at a specified date and time , and leaves maintenance mode at a specified date and time.

 


Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse