The MSSQL_FileGroup class represents the groups of operating system files that store a database. A SQL Server filegroup categorizes the operating system files containing data from a single SQL Server database to simplify database administration tasks, such as a backup. A filegroup cannot contain the operating system files of more than one database, though a single database can contain more than one filegroup.
Default Collection Interval — in real time
Table 1-56 MSSQL File Group Metrics
Metric | Description |
---|---|
DatabaseName (key column) |
Name of the database. |
Filegroup Name (key column) |
File Group name. |
Default |
Whether the file group is the default file group during table or index creation. |
File Group Free Space (MB) |
Available free space for file group. |
File Group Used Space (MB) |
Used space for file group. |
Read Only |
Whether the file group is read only. |
Total Size of the File Group (in MB) |
Total size of the file group in megabytes. |
Type |
File group type. A database is created on exactly one file group named PRIMARY. This is the primary file group. After database creation, you can add a file group to the database, called a user-defined file group.
|