How do we determine the AvailablePages column and what is considered a Non-extensible file? (4263251)

How do we determine the AvailablePages column and what is considered a Non-extensible file?

How do we determine the AvailablePages column and what is considered a Non-extensible file?

A non-extensible file is a file discovered by the collection that is about to run out of space.

The AvailablePages is calculated as follows:

1. Take max_size from sys.master_files.
2. If it is equal to -1 then AvailablePages is PagesFree (where PagesFree is extracted from the output of execute sys.xp_fixeddrives)
3. If max_size >= PagesFree then AvailablePages is PagesFree (where PagesFree is extracted from the output of execute sys.xp_fixeddrives).
4. Else, if neither of the above conditions is true then AvailablePages is max_size.

In the case of the NextPagesSize, this is dependent on whether the growth is a percentage or an amount. If the growth is a percent, this is calculate as follows:

NextPagesSize = Size + Size * growth / 100 (where Size and growth is extracted from sys.master_files)

If the growth is not a percentage, NextPagesSize is calculated as:

NextPagesSize = Size + growth (where Size and growth is extracted from sys.master_files)

It would help to investigate the outputs from the select * from sys.master_files and execute sys.xp_fixeddrives commands.