Environment
Situation
Resolution
If VPC behaves during the sync process is taking a lot of time to add a new external repository, then we recommend that you run the Microsoft SQL Index Defrag script which you can find at http://msdn.microsoft.com/en-us/library/ms177571.aspx (Examples > Section B. Using DBCC SHOWCONTIG and DBCC INDEXDEFRAG to defragment the indexes in a database) Running the Index Defrag script you should expect an improvement in the time of sync a new external repository.
To execute the Index Defrag script:
- Login into SQL Query Analyzer as "vpc_user" or the name that was selected in the NetIQ-VPC installation process.
- Execute the Defrag Script. It is very important that you execute this script with the name of the user was selected in the NetIQ-VPC installation process.
Cause
Additional Information
NetIQ STRONGLY recommends taking a complete / full back up of the VPC database prior to any changes being made. The cleanup script is coppied out to the VPC Server local file system after the VPC Install is complete. The Clean Up Script is located in the following location:
<Path to VPC Install Folder>\NetIQ\VigilEnt Policy Center\database\cleanup