Reindexing is already taking place against the OperationsManager database for some of the tables (but not all, and this is important to understand!). This is built into the product. What we need to ensure – is that any default DBA maintenance tasks are not conflicting with our built-in maintenance, and our built-in schedules:
There is a rule in OpsMgr that is targeted at the All Management Servers Resource Pool:
The rule executes the “p_OptimizeIndexes” stored procedure, every day at 2:30AM.