Repair Channergy tables all at once then have them optimized to improve performance speed and reliability.
Instructions will be sent with the utility and are below:
Download and install the utility on your server computer.
1. The installer will prompt you for a folder to install it into, make sure that you select the Program Files folder for your current Channergy installation, For instance, if you are running Channergy 2016, make sure that the installation folder is C:Program Files (x86)Channergy 2016. That is how the application (RepairOptimizeTables) knows where the database files are located.
2. The installer will put a shortcut on your desktop. When you run the application, make sure that you right-click on the icon and select Run as Administrator… You can make so that it always does that (Run as Administrator) by doing the following.
1. Right-click on the Icon and select the Properties option from the context menu.
2. Click on the Compatibility tab.
3. Click on Change settings for all users at the bottom of the Compatibility tab
4. Click on the checkbox next to Run this program as an administrator
5. Click OK to close the Compatibility for all users window and click OK again to close the RepairOptimize Properties window.