SQL Diagnostic Manager allows multiple simultaneous status indicators for each individual database, very similar to what you see in Microsoft SQL Server Management Studio. You can see the status of a database in the Servers tree by expanding the associated Server tree. The status displayed matches what is shown in Microsoft SQL Server Management Studio in all cases where Management Studio displays a status.
Database alerts and statuses
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
Alerting is based on the most critical status associated with a database at the time of collection.
Note that for certain metrics, using the informational alert means that you no longer receive a warning or critical alert for events generated by that metric. Please review the situation before setting up an informational alert.
To 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.