Perform an Offline SQL Re-Index in vRealize Configuration Manager to remediate slowness
search cancel

Perform an Offline SQL Re-Index in vRealize Configuration Manager to remediate slowness

book

Article ID: 343085

calendar_today

Updated On:

Products

VMware VMware Aria Suite

Issue/Introduction

If you have had vRealize Configuration Manager running for over 6 months and started to notice slow performance issues in the UI, you likely need to run an Offline SQL Re-Index and set up a maintenance plan to ensure optimal performance.

Symptoms:
  • vRealize Configuration Manager has been running for over 6 months.
  • Slow performance issues in the UI.


Environment

VMware vRealize Configuration Manager 5.x
VMware vCenter Configuration Manager 5.x

Resolution

To run an offline re-index, follow the steps below:
  1. Ensure jobs have completed and stop the collector service through the UI by going to Jobs > Collector Status > Click "Stop".
  2. Stop the SQL Agent service on the SQL Server by going to Windows Services.
  3. Open SQL Server Management Studio.
  4. Select "New Query" and ensure that "VCM" is selected in the drop down for the databse.
  5. Run:  EXEC sp_MSforeachtable @command1='DBCC DBREINDEX (''?'', '' '', 0)' in  a SQL query window.
Note: You can run the reindex with services started but it will take much longer to complete

The reindex can take anywhere from a few hours to a day or more depending on how much work is needed and the size of the DB.   
Furthermore, please ensure that you have a maintenance plan set up to run weekly to ensure the performance is optimal.  
The maintenance plan configuration can be found starting on page 164 of the Advanced Installation Guide.