Date: Fri, 29 Mar 2024 11:23:42 +0000 (UTC) Message-ID: <1151286660.69945.1711711422062@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_69944_142779329.1711711422060" ------=_Part_69944_142779329.1711711422060 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
SQL Diagnostic Manager allows mul= tiple simultaneous status indicators for each individual database, very sim= ilar to what you see in Microsoft SQL Server Management Studio. You ca= n see the status of a database in the Servers tree by expanding the associa= ted Server tree. The status displayed matches what is shown in Microsoft SQ= L Server Management Studio in all cases where Management Studio displa= ys a status.
The following alerts and statuses are associated with Database status:= p>
Default St= atus Level |
Alert/Stat= us |
Descriptio= n |
---|---|---|
OK |
Normal |
Everything is okay and the database is operat= ing 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 recove= ry. |
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. = td> |
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 ope= n the database. A serious issue such as a disk failure can cause an inacces= sible database. |
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 befo= re setting up an informational alert.