You may encounter performance issues with Everest, such as slow loading browsers, long execution times for queries, and delays in searching invoices.
This can happen due to environmental factors on the client's workstation, Everest server, or both.
Performance issues in Everest are often characterized by slow loading times when users execute various actions on the UI and are usually be due to environmental factors.
To narrow down the root cause and begin resolution, it is important to establish whether the issue is only happening to a particular workstation/client or if the performance issue is experienced by all users.
The first scenario points to a User Profile issue that can be resolved by resetting the Everest workstation and User settings for the user on the impacted workstation back to the defaults as described below:
- Reset the Workstation settings:
File > Setup > Preference > Workstation Settings > Interface > Reset All Menus
- Reset the User Settings:
File > Setup > Interface Settings > look for user-code > Right-Click > Restore to Factory Settings > All Settings
- Ensure DEP is enabled by following these steps on the specific workstation having the issue:
- Open Windows Explorer > highlight 'Computer' > Right-click > Properties
- Select Advanced System Settings on the System properties window
- Select 'Advanced' tab > Click on 'Settings' under 'Performance'
- On Performance Options window > select 'Data Execution Prevention' tab
- Check 'Turn on DEP for essential Windows programs and services only'
- Select 'Apply' and close the window
- Reboot the workstation.
For the second scenario where the performance issue is affecting multiple or all users, execute the steps described in either of the two methods outlined below to defragment and rebuild the indexes and restore optimal performance:
- Please ensure that a complete backup of the database is complete before making any changes.
- Ensure all the users are logged out of Everest.
- Ideally, defragmentation and reindexing should be done after hours. (This is applicable for both methods).
- Admin access is required to the Everest application and/or SQL Server Management Studio.
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.
The above actions should restore optimal performance but if the issue persists, submit a support request for further assistance.