Do I need to run maintenance on MY SCOM DBs ?

 

This question came from Momo my DBA Friend, I have SCOM 2012 installed , what kind if maintenance Plan I need to run, Momo meant DBCC check, Index rebuild etc..

my answer nothing , you don’t need to run any maintain on SCOM DBs and the  reasons are the following :

1- there is a rule name “Optimize Indexes” that execute a daily database maintenance it calls a Store Proc name “p_OptimizeIndexes” , by default the rule runs once a day  at 2:30 AM , you can change the time (Configuration Tab,View DS  ),

image

the index optimization Store Proc has the following

image

Comments are closed.