Filegroup space usage
Log file space metrics are shown under an artificial LOG filegroup for each database.
(db_name, fg_name)
| Name | Data Type | Description |
|---|---|---|
| database_id | long | Database ID |
| filegroup_id | long | Filegroup ID; 0 = Log files |
| db_name | string(260) | Database name |
| fg_name | string(260) | Filegroup name; LOG = Log files |
| file_count | long | Number of files in the filegroup |
| notonline_file_count | long | Number of files in the filegroup that are not online |
| readonly_file_count | long | Number of files in the filegroup that are marked read-only |
| suspect_file_count | long | Number of files in the filegroup that have suspect pages |
| suspect_pages | long | Number of suspect pages in the filegroup |
| has_storage | string(8) | Whether an extent has been allocated yet in every file |
| status | string(124) | Filegroup status (ONLINE, SUSPECT, UNAVAILABLE) |
| used_pct | double | % of total usable space (database + OS) that is used |
| is_sparse | string(8) | Whether any file in the filegroup is a sparse file (i.e. for snapshots) |
| used_space | double | Amount of space used in the filegroup, in bytes |
| free_space | double | Total unused space, in bytes, over all OS volumes holding files from this filegroup |
| db_used | double | Amount of space (database) used in the filegroup, in bytes |
| db_free | double | Unused space (database), in bytes |
| db_unusable | double | Amount of unusable space (database), in bytes |
| db_total | double | Total allocated size (database) for the filegroup, in bytes |
| os_used | double | Amount of space (OS) used in the filegroup, in bytes |
| os_free | double | Total unused space (OS), in bytes, over all OS volumes holding files from this filegroup; if OS free space is too small for next (grown) file extent for a file, then that will be shown under os_unusable, and the value considered here, for that file on that volume, will be 0 |
| os_unusable | double | Total amount of unusable space (OS), in bytes, over all OS volumes holding files from this filegroup; for example, OS free space that is too small for next (grown) file extent |
| os_total | double | Total allocatable size (OS) for the filegroup, in bytes, over all OS volumes holding files from this filegroup |
| is_growth_unlimited | string(8) | Whether any file in the filegroup has growth unlimited |
| max_size | double | Total maximum size, in bytes, imposed on the filegroup over all files; 0 = On all files, no growth allowed or unlimited growth (subject to OS space); the meaning of this value will be ambiguous if a filegroup has a mix of unlmited growth and limited growth files |
| db_used_pct | double | % of total usable space (database) that is used |
| total_space | double | Total allocatable size for the filegroup, in bytes, over all OS volumes holding files from this filegroup |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| DB_USED_RATE | double | Additional amount of space (database), in bytes, used in the filegroup per second, in interval |
| DB_USED_RATE_AVG | double | Average additional amount of space (database), in bytes, used in the filegroup per second, since collection started |
| DB_USED_MB | double | Amount of space (database) used in the filegroup, in megabytes |
| OS_USED_MB | double | Amount of space (OS) used in the filegroup, in megabytes |
| FREE_MB | double | Total unused space, in megabytes, over all OS volumes holding files from this filegroup |
| DB_USED_DELTA | double | Delta amount of space (database) used in the filegroup, in bytes |
| DB_USED_DELTA_AVG | double | Average of delta amount of space (database), in bytes, used in the filegroup, since collection started |
| Attributes: | None |
|---|---|
| Minimum database version: | 9.0 |