1.20 Database

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:

  •         0 — Normal

  •       32 — Loading

  •     192 — Recovering

  •     256 — Suspect

  •     512 — Offline

  •   1024 — Standby

  • 32768 — Emergency Mode

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