Fragmentation of indexes is a large concern and performance impact on the Symantec Management Platform database (Symantec_CMDB).
It can affect many areas of the product including console performance, replication and client data processing.
Index fragmentation is a normal process that happens as data is added and removed from a database. Maintenance needs to be in place to address it.
Note: The attached script can be run using any available method, such as an SQL Job, SQL Maintenance Plan for Scripts, Task Server task from the product etc.
The attached script has the following benefits:
IMPORTANT: If the name of the database is not the default Symantec_CMDB. Please make sure to change the top line of the script from USE Symantec_CMDB to USE <Non Default DB Name>
Example steps for creating an SQL Job on SQL Server 2008 R2