Recently, we have been observing a lot of file fragmentations that are happening in the production environments.

To identify how many files being impacted with this file framentation, As part of the checkpoint, whenever the checkpoint is happening, calculate the number of files that have reusable file space that is greater than 50% of the entire file size.