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

Products

• 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