Press the "Run" button to create a report. You can also save the report as a TXT file.
|If you encounter a problem, please send us a full diagnostic report via e-mail.|
The "Indexes" tab shows you the fragmentation of the Cinegy Archive database.
|This is an on-line operation.|
The fragmentation of the system indexes affects the SQL Server performance significantly. Monitor the status daily to keep your indexes tidy.
|Defragmentation must be done on the minimum SQL Server load to avoid affecting the users' work.|
All highly fragmented indexes will be shown in red; medium fragmented indexes – in yellow. Also check "% of fragmentation" to see the fragmentation level. Highly fragmented indexes are automatically checked. Press the "Defragment" button to start the defragmentation process.
|The defragmentation may take a while.|
|This is an off-line operation.|
Back up your Cinegy Archive database.
Disconnect all clients before you rebuild the indexes.
Press the "Rebuild" button.
|Rebuilding may be necessary after changing the Cinegy Archive database structure (e.g. applying some upgrade scripts).|
|It is recommended to have no active connections to the Cinegy Archive database when performing the rebuilding operation.|