You may encounter performance issues with Everest, such as slow loading browsers, long execution times for queries, and delays in searching invoices.
This article provides the two methods to defragment and rebuild the indexes to improve the performance:
- Admin access is required to the Everest application and/or SQL Server Management Studio.
- Ensure all the users are logged out of Everest.
- Ideally, defragmentation and reindex should be done after hours.
(This is applicable for both methods.)
Method 1: Via SQL Server Management Studio
- In SQL Server Management Studio, select the Everest database.
- Open New Query for the selected database.
- Execute the stored procedures on the
EVEREST_xxxxxxdatabase in the order given below:
Exec DATABASE_REINDEXto reindex the database.
Exec INDEX_DEFRAGMENTATIONto defragment the index.Note: The stored procedures will display all changes made. Execution may take several hours, depending on the size of the database.
Method 2: Via Everest Interface
- You can reindex the database and defragment the index directly from the Everest user interface.
- From the Everest user interface, go to Utilities > Database Maintenance > Rebuild Indexes. This executes the
DATABASE_REINDEXprocedure that triggers the reindexing process.Note: This should take from 30 min up to a couple of hours according to your database size, I/O rate.
- From the Everest user interface, go to Utilities > Database Maintenance > Defrag Indexes. This executes the
INDEX_DEFRAGMENTATIONprocedure that triggers the index defragmentation process.Note: This needs to be executed on a more frequent basis than the index rebuild job.
Note: If performance issues persist after following this procedure, please contact Support.