Page History
...
The following alerts and statuses are associated with Database status:
Default Status Level | Alert/Status | Description |
|---|---|---|
OK | Normal | Everything is okay and the database is operating normally. |
OK | Standby | The database is in standby mode. |
OK | Read Only | The database is in read-only mode. |
OK | Single User | The database is in single-user mode. |
OK | Restore Mirror | Restoring the database mirror. |
OK | Undetermined | No information is available one this database. |
OK | Cleanly Shut Down | The database is shut down and needs no recovery. |
OK | DBO Use Only | The database is in a dbo-use mode (restricted_user). |
Warning | Restoring | Restoring the database. |
Warning | Recovering | Recovering the database. |
Warning | Recovery Pending | The database recovery is not yet begun. |
Warning | Offline | The database is offline. |
Critical | Suspect | The database integrity is suspect. |
Critical | Emergency Mode | The database is in emergency mode. |
Critical | Inaccessible | The SQLdm Monitoring Service is unable to open the database. A serious issue such as a disk failure can cause an inaccessible database. |
Change the default alert status level
...
- Right-click any server in the Servers tree.
- Select Configure Alerts.
- Select Database Status from the list of alerts.
- Double-click any of the values on the Configuration tab.
- Edit each alert to associate it with the desired alert status level.
| Scroll pdf ignore | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL SQLDiagnostic Manageridentifies and resolves SQL Server performance problems before they happen. Learn more > >for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
| ||||||||||||||||||||||||||||||||||||||||||||||||||
| Newtabfooter | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal