The MSSQL_Database class represents a SQL Server database. Each SQL Server installation can contain one or more databases.
Default Collection Interval — Every 15 minutes
Table 1-25 Database Metrics
Metric | Description and User Action |
---|---|
Database Name (key column) |
Database name. |
Create Date |
Time and date the database was created. |
Database File Path |
Primary location of the database files. |
Database Mirroring State |
State of the mirror database and the database mirroring session. |
Database Mirroring Partner Name |
Server name of the database mirroring partner. |
Database Mirroring Partner Instance |
The instance name for the other partner. |
Database Status |
Status of the database:
|
Database Size (MB) |
Total size of the database in megabytes. Allocate more space to the database if this metric decreases beyond the critical threshold. |
Database Space Available % |
Percentage of space that is available. Allocate more space to the database if this metric decreases beyond the critical threshold. |
Auto-growth Potential Space (MB) |
Amount of disk space available for the database to grow in to based on its autogrowth settings. |
Version |
Version of Microsoft SQL Server used to create the referenced database. |
Database Owner |
The owner of the database |
Database ID |
The ID of the database |