Performance Issue: Slow Running

Overview

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.

Solution

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:

1. Reset the Workstation settings:
   File >  Setup > Preference > Workstation Settings > Interface > Reset All Menus
2. Reset the User Settings:
   File > Setup > Interface Settings > look for user-code > Right-Click > Restore to Factory Settings > All Settings
3. Ensure DEP is enabled by following these steps on the specific workstation having the issue:
   1. Open Windows Explorer > highlight 'Computer' > Right-click > Properties
   2. Select Advanced System Settings on the System properties window
   3. Select 'Advanced' tab > Click on 'Settings' under 'Performance'
   4. On Performance Options window > select 'Data Execution Prevention' tab
   5. Check 'Turn on DEP for essential Windows programs and services only'
   6. Select 'Apply' and close the window
   7. 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:

1. Via SQL Server Management Studio
2. Via Everest Interface

Method 1: Via SQL Server Management Studio

1. In SQL Server Management Studio, select the Everest database.
2. Open New Query for the selected database.
3. Execute the stored procedures on the EVEREST_xxxxxx database in the order given below:
   
   1. Exec DATABASE_REINDEX to reindex the database.
   2. Exec INDEX_DEFRAGMENTATION to 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

1. You can reindex the database and defragment the index directly from the Everest user interface.
2. From the Everest user interface, go to Utilities > Database Maintenance > Rebuild Indexes. This executes the DATABASE_REINDEX procedure 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.
3. From the Everest user interface, go to Utilities > Database Maintenance > Defrag Indexes. This executes the INDEX_DEFRAGMENTATION procedure that triggers the index defragmentation process.
   Note: This needs to be executed on a more frequent basis than the index rebuild job.

Testing

The above actions should restore optimal performance but if the issue persists, submit a support request for further assistance.

Back to top