Sage X3 Tips & Tricks: What is the AIOBENCH function and How to Use It

The objective of the AIOBENCH tool is to warn partners and customers if the environment (server, network, and virtualization options) supporting their Sage X3 application does not meet the minimum requirements for Sage X3 to operate efficiently. The tool measures database throughput times by creating temporary tables, populating them, and executing intensive queries on them. When complete, the tool provides statistical values for the various tests performed and reveals if minimal performance expectations are met.

Prior to Sage X3 Version 12 Patch 24, the process to run was more manual. Now, starting in Version 12 Patch 25, it's easier to run!

How to Run the AIOBENCH Function

Before we proceed to the how, please note the following two points. It is recommended that the tool be run when X3 has little to no activity. We recommend avoiding running the function during high-peak times of X3 usage, as it causes a performance load on the X3 system for several minutes, which may interfere with daily processing.   After logging into X3, switch to the X3 folder. You will get an “Unauthorized function” error, and the task will not launch.

1. Log in as an ADMIN user and change to the X3 folder.
2. Navigate to Development > Utilities > Verifications > Database > Performance Index (AIOBENCH)
   
   
3. When the Performance index screen is displayed, click on the Execution button.
4. Next, a small screen will appear with a message to let you know the task is about to run. Click Yes to proceed.
   
5. After the task is completed, a log will be displayed.
   
6. Locate the Performance Index entry section in the log and review it to assess the performance results. The number of seconds should be in the Good or higher range (100 seconds or lower). As you can see in this example, the performance index is only average.
   
7. Also note that the AIOBENCH function stores previous runs that can be reviewed and compared.