Your CA DataMinder database automatically includes a set of base indexes. These were chosen for their ability to speed up common queries such as captured data searches based on event, trigger or user properties. To ensure optimum performance, these indexes must be properly maintained.
Defragment the Database Indexes
For SQL Server databases, you must regularly defragment the database pages that hold index data and keep your database statistics up to date.
In particular, we strongly recommend that you defragment your indexes after running the Wgn_Queryflags_Migrate stored procedure (SP). This is an optional post-upgrade SP that runs on the CMS to optimize CA DataMinder search and report performance. After the SP has completed, some database indexes will be heavily fragmented becuase of the data updates. We strongly recommend that you run your standard index maintenance routines at the earliest convenient opportunity to remove any temporary performance degradation due to this index fragmentation.
For full details about maintaining indexes, see your SQL Server documentation.
|
Copyright © 2014 CA.
All rights reserved.
|
|