Autogrowth Setting in SCOM 2012 R2 are pretty static

After running System Center Operations Manager 2012 R2 for a week, I began getting these errors: Ops DB Free Space Low – And amazingly the default setting on the Operations Manager database are Autogrowth = None, which will work in a production environment for about 17 minuttes. So remember to change this when you do the installation or afterwards – by changing the InitialSize (MB) to appr 50 GB (The largest OperationsManager database I’ve ever seen at a customer where 180GB)

 

SQLDBSetting 

 

Change it according to your database size calculations or at least!!

changeDBvalues

 

Have a great day

Kåre

PS Remember I still have one Advanced SCOM training in Minneapolis this year – 3 days in week 49 (2.-6. december)

By | 2013-10-25T10:11:43+00:00 October 25th, 2013|Operations Manager (SCOM)|2 Comments

About the Author:

Kåre Rude Andersen
Microsoft Certified Trainer since 1996, MCSE, TS and ITP in Microsoft Windows, SQL (also Microsoft), Exchange (MS) and Microsoft Operations Manager. Senior Consultant and have recently worked as a consultant at CSC, SAS, ISS, Nokia and Scandlines.

2 Comments

  1. RAO October 26, 2013 at 11:39 - Reply

    This is actually a good thing…. Msft always recommended having a static type of db, as a dynamically expendig db is quite an expensive one which causes locking, fragmentation, slowness etc. I bet its still to suto grow for opsdw.
    Whatever the setting, its always recommended to use the sizing tool and the create a db With size that suits ur environment and needs… not 10, 20 or 30 Gb.

  2. Kåre Rude Andersen October 26, 2013 at 12:15 - Reply

    Exactly RAO – Change it accordingly to the size calculations

Leave A Comment