Information that can be obtained from this grid includes:
The name of the specified database.
The name of the data file.
The name of the file group to which the file belongs.
The size of the file.
The amount of file space that is actually used, measured in megabytes.
The amount of unused space, measured in megabytes.
The percentage of space allocated to objects.
Whether the file can grow automatically as it fills.
For data files that can grow and show few growths remaining, consider allocating more disk space for the data files to grow. Check also the Auto Grow and Growth Increment values.
The maximum size that the file can grow to.
Growth increment. The amount by which the file can AutoGrow at any one time.
The location of the file.
The percentage of space not allocated to any objects.
The type of file group. For example, data or log.
How to highlight records
You can restrict the files included in the charts by highlighting just the records you are interested in. Hold down the Shift key to select a block of multiple files or the CTRL key to select individual files.
How to filter the results
To filter the files displayed in the grid, type a category of file group into the File Group field and then click Apply Filter. Only those files that belong to the specified file group are displayed in the grid. You can use the percent sign (%) as a wildcard.