White Papers

35 Dell Compellent Storage Center Management Pack 3.0 for Microsoft SCOM 2012/R2 Best Practices
6.5 SQL database settings
SCOM requires a SQL database, and will create one during the installation. The size and destination of the
database can be set, as shown in Figure 13.
Figure 13 SCOM operational database setup
In most cases, the default database size of 1 GB is too small, especially in environments with multiple
storage centers and a high number of volumes.
It should also be noted that by default, the SCOM operational database is not set to autogrow, regardless
of what the SQL server defaults are set to.
Figure 14 Operations Manager database properties