STAY IN TOUCH

Get New posts delivered straight to your inbox

  • Madeira Team

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

JOIN OUR MAILING LIST

CONTACT US

 3 Rapaport St. Kfar Saba, Israel

 +972-9-7400101

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