The diagnostics and tuning panel is launched via the respective command from the "Consistency checking and diagnostics" submenu of the database context menu:
Launched for the first time the panel looks as follows:
Press the "Run" button to create a report containing details on SQL server, database, sessions, etc.:
Use the "Save as" button to save the generated report as a TXT file to your local machine.
|If you encounter a problem, please send us full diagnostic report via e-mail.|
The "Indexes" tab shows you the fragmentation of the Cinegy Archive database:
|This is an online operation.|
The fragmentation of the system indexes significantly affects the SQL Server performance. Monitor the status daily to keep your indexes tidy.
|To avoid affecting the users' work, defragmentation on the SQL Server must be done when its load is minimal.|
All highly fragmented indexes will be shown in red; medium fragmented indexes – in yellow. Also check the "% 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 offline operation.|
As heavily fragmented indexes can degrade query performance and reduce capacity, you can reorganize or rebuild one or more fragmented indexes in SQL Server for the selected database. To do this, follow the steps below:
Back up your Cinegy Archive database.
Disconnect all clients before you rebuild the indexes.
Press the "Rebuild" button.
On the "Active user connection" window that appears, press the "Continue" to proceed with index rebuilding or "Cancel" to abort the operation:
|Rebuilding may be necessary after changing the Cinegy Archive database structure (e.g. applying some upgrade scripts).|
|It is recommended to leave no active connections to the Cinegy Archive database when performing the rebuilding operation.|