A proactive DB maintenance job is scheduled in the SQL Server Management Studio, as a SQL Agent Job, and is scheduled to run every 30 minutes.
This job uses the QS_SetupCSProactiveDBMaintainanceSQLJob qscript to run the Online Index Defrag tool, available in SQL 2014+, to monitor index fragmentation. It attempts to defragment the identified indexes when they exceed a certain criteria, in the online mode, and attempts to keep the CommServ database from becoming heavily fragmented. It also monitors the CPU usage of the server to avoid impacting the Commserve operations, and performs as much defragmentation as possible, based on available CPU cycles.
Although Commvault recommends the DBMaintenance Workflow to be scheduled every other week, during slow CommServe activity workloads, it can be disabled if the Online Index Defrag tool is managing to keep up with index fragmentation. However, on a heavily active CommServe, it must be investigated to see if the defragmentation is possible based on the load factor. The proactive DB maintenance job can be disabled, if necessary.
Related Topics
-
For more information on this QScript, see QS_SetupCSProactiveDBMaintainanceSQLJob.
-
For more information on executing QScripts, see QScripts on the Command Line.