Syncsort™ Capacity Management’s Control Center inserts data into the database and SQL Server will maintain a number of indexes to this new data to be able to retrieve it quickly. Over time the efficiency of these indexes will degrade and they need to be reorganized and sometimes rebuilt to put them back into good working order. In addition, SQL Server maintains a set of statistics that help it choose the optimal means of getting to data. Again, over time, if these statistics are not updated, they become less helpful and in some cases can be distinctly bad for performance.
Your SQL Server DBA should have routines and procedures to maintain and manage the restoration of these performance-related items for you.
Included with the Syncsort™ Capacity Management Portal is a means to run a script on a scheduled basis. One script provided for you will examine and defragment indexes on all Capacity Database tables. You can set this to run at some convenient time and interval and also set a maximum elapsed run time. Once that run time is exceeded the defragmenting stops, when the “current” task completes - it does not cancel anything that is already running.