MSSQL Database File
The MSSQL_DatabaseFile class is an extension to the CIM_DataFile class. It contains properties that are relevant to an operating system file that is also a file storing SQL Server database data.
Default Collection Interval — Every 30 minutes
Table 2-55 MSSQL Database File Metrics
| Metric | Description |
|---|---|
|
Database File Name (key column) |
User name. |
|
Database Name (key column) |
Name of the database. |
|
FileGroup Name (key column) |
Name of the File Group. |
|
Database File Path |
Complete path of the database file. |
|
Datafile Free Space (MB) |
Available space for data file |
|
Datafile Used Space (MB) |
Used space for data file |
|
File Growth |
Growth increment of the operating system file that stores table, index, or log data. When FileGrowthType is in megabytes, the FileGrowth value represents the number of megabytes of disk space to allocate for incremental file growth. When FileGrowthType is percent, the value represents a percentage and must be in the range from 1 through 100. |
|
File Growth Type |
Method of incremental allocation applied when an operating system file is extended.
|
|
Maximum Size |
Upper limit for the size of an operating system file containing table and index data, or maintaining a database transaction log. |
|
Normalized (for autogrowth) Maximum File Size (MB) |
Maximum file size of the database. |
|
Primary File |
Whether the database file is the one that maintains the database-specific system tables. A Microsoft SQL Server database can have only one primary file. |
|
Space Available in MB |
Amount of disk resources, in megabytes, allocated and unused in operating system files. |
|
Database File Space Available (%) |
Percentage of space available for the database file. If file autogrowth is enabled, the percentage of space available to the largest possible database file. |
|
Size (MB) |
Current size of the database file. |