Maintenance Mode allows you to temporarily stop alert generation and the collection of some performance metrics for the time period that your SQL Server instance is offlineselected SQL Server instances. Using Maintenance Mode allows you to decrease alert notification spam and the collection of unnecessary dataon one instance does not prevent the collection of performance metrics and notifications for those instances that are not in Maintenance Mode.
| Note |
|---|
If you open a SQL Diagnostic Manager dashboard for an instance that is in Maintenance Mode, real-time data collection will be attempted. |
| Tip |
|---|
It is possible to enable or disable maintenance mode on several SQL Server instances, see About Mass Maintenance Mode. |
...
If you have a SQL Server instance in Maintenance Mode and are ready to bring it back online in SQL Diagnostic Manager, click Maintenance Mode on the Server Overview tab.
| Scroll pdf ignore |
|---|
| Newtabfooter |
|---|
| alias | IDERA |
|---|
| url | http://www.idera.com |
|---|
|
| | Newtabfooter |
|---|
| alias | Products |
|---|
| url | https://www.idera.com/productssolutions/sqlserver |
|---|
|
| | Newtabfooter |
|---|
| alias | Purchase |
|---|
| url | https://www.idera.com/buynow/onlinestore |
|---|
|
| | Newtabfooter |
|---|
| alias | Support |
|---|
| url | https://idera.secure.force.com/ |
|---|
|
| | Newtabfooter |
|---|
| alias | Community |
|---|
| url | http://community.idera.com |
|---|
|
| | Newtabfooter |
|---|
| alias | Resources |
|---|
| url | http://www.idera.com/resourcecentral |
|---|
|
| | Newtabfooter |
|---|
| alias | About Us |
|---|
| url | http://www.idera.com/about/aboutus |
|---|
|
| | Newtabfooter |
|---|
| alias | Legal |
|---|
| url | https://www.idera.com/legal/termsofuse |
|---|
|
| IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal
|---|