• Eitan Blumin

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

CONTACT US

 3 Rapaport St. Kfar Saba, Israel

JOIN OUR MAILING LIST

 +972-9-7400101

  • Google+ - White Circle
  • Facebook - White Circle
  • Twitter - White Circle
  • LinkedIn - White Circle