Showing posts with label autogrowth. Show all posts
Showing posts with label autogrowth. Show all posts

Friday, 10 April 2015

SCOM 2012 R2 Autogrowth settings are static!

After using SCOM 2012 R2 for a few weeks we started to get "Free Space Low" alerts for it's own databases.

On investigation the default SQL instance has been setup with Autogrowth set to None.  So remember to change this to something more appropriate after installation or you'll soon run into some issues.

As a minimum I changed the settings to be:

MOM Data 
Initial size: 5000MB
Autogrowth: 1000MB, unlimited


MOM Log
Initial size: 1000MB
Autogrowth: 100MB, unlimited