Space Used by Database Files

Retrieve data about size and space used for all the files in the current database with this script. Some tips on database file size management:

  1. Make sure there is enough unallocated space for future growth.

  2. If the value of “UnallocatedSpace_Percent” is low, consider allocating more space in the next maintenance window.

  3. Auto-growth should be enabled as a safety measure.

  4. Do not attempt to shrink files, unless you really have to. See this post on When and How to Shrink Your Database for more information.

#healthcheckservice #databaseadministration


Recent Posts

See All