Name: Autogrow settings
Platform: Sqlserver
Category: Maintenance
Description: Checks database files auto-growth settings.
Long description: The default auto-grow settings associated with the model database are not the best settings for how databases grows. If you haven’t been diligent at setting the auto-grow parameters when you created databases then you might want scan your instance to determine which databases are using the default setting. We have split the possible file sizes and growth settings into 4 renges. The first range, which we do not analyze, are files smaller than ‘minimum file size STEP 1’. The second rage, files between ‘minimum file size STEP 1’ and ‘minumum file size STEP 2’, are verified to have file growth settings equal ‘minimum growth size SPEP 1’. The third ragen, files between ‘minimum file size STEP 2’ and ‘minumum file size STEP 3’, are verified to have file growth settings equal ‘minimum growth size STEP 2’. The last rage verified that all files (bigger than ‘minimum file size STEP 3’) have minimum growth settings equal or higher than ‘minimum growth size STEP 3’ and at the same time lower than ‘maximum growth size STEP 3’. Only ONLINE databases with the following properties are included: UserAccess = MULTI_USER, Updateability = READ_WRITE, IsInStandBy = 0, IsMergePublished = 0, IsPublished = 0 and IsSubscribed = 0.
Version: 2.1
Default schedule: 15 15 1 *
Requires engine install: Yes
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005’ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ | engine_edition = ‘Azure SQL Managed Instance’)


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment