UIM Best Practices - Indexes that require defragmentation (daily) - SQL Server

Article Id: 196521
Status: Published
Updated On: 10-09-2020 14:20
Products:
DX Infrastructure Management , NIMSOFT PROBES , DX Infrastructure Management
Issue/Introduction:

UIM Best Practices - Indexes that require defragmentation (daily) - SQL Server

Environment:

Release : Any UIM Release

SQL Server DB

Resolution:

 Indexes that require defragmentation (daily)


Here is a list of tables that you CAN run a daily index defrag job upon:

ALTER INDEX ALL ON CM_COMPUTER_SYSTEM REBUILD; 
ALTER INDEX ALL ON CM_DEVICE REBUILD; 
ALTER INDEX ALL ON CM_COMPUTER_SYSTEM_ATTR REBUILD; 
ALTER INDEX ALL ON CM_DEVICE_ATTRIBUTE REBUILD; 
ALTER INDEX ALL ON CM_CONFIGURATION_ITEM REBUILD; 
ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_METRIC REBUILD; 
ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_DEFINITION REBUILD; 
ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_METRIC_DEFINITION REBUILD; 
ALTER INDEX ALL ON CM_NIMBUS_ROBOT REBUILD; 
ALTER INDEX ALL ON CM_DEVICE REBUILD; 
ALTER INDEX ALL ON CM_COMPUTER_SYSTEM_ORIGIN REBUILD; 
ALTER INDEX ALL ON CM_CONFIGURATION_ITEM_ATTRIBUTE REBUILD; 
ALTER INDEX ALL ON CM_RELATIONSHIP_CI_CI REBUILD; 
ALTER INDEX ALL ON CM_RELATIONSHIP_CI_CS REBUILD; 
ALTER INDEX ALL ON CM_RELATIONSHIP_CS_CI REBUILD; 
ALTER INDEX ALL ON CM_DISCOVERY_NETWORK REBUILD; 
ALTER INDEX ALL ON S_QOS_DATA REBUILD; 
ALTER INDEX ALL ON NAS_TRANSACTION_SUMMARY REBUILD; 
ALTER INDEX ALL ON NAS_ALARMS REBUILD; 
ALTER INDEX ALL ON NAS_TRANSACTION_LOG REBUILD;

Additional Information:

How to check the DB Fragmentation level for SQL Server

https://knowledge.broadcom.com/external/article?articleId=73421