Skip to content
logo Knowledgebase

What is Sage X3 performance measurement tool: AIOBENCH

Created on  | Last modified on 

Description


Cause


Resolution

CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.


The objective of this tool is to warn partners and customers if their environment (server, network, virtualization options) is not coping with the minimal expectations required for Sage X3 to operate at a good level of performance. It measures the database throughput by creating temporary tables, filling them, and performing heavy queries on them. It gives at a glance a composite index value that tells if the platform is suitable or not for Sage X3. 

In the virtualization section of the Architecture guide of X3 there is a portion that states:

 

  V11 guide : To help determine the quality of an infrastructure regardless of its nature (physical or virtual, single or multi-tier, Oracle or SQL Server, Unix-Linux or Windows, etc.), Sage can provide a test program to meter X3’s performance by performing a set of data I/O operations of the reference folder to simulate some high-demand transactions. 

The results of this program can help to compare metered performance to known reference systems and feedback from other customers’ production infrastructures 

  PU9 guide : To help determine the quality of an infrastructure regardless of its nature (physical or virtual, mono or multi-tier, Oracle or SQL Server, Unix-Linux or Windows, etc.), Sage can provide a test program to meter the performance of its software application that carries out seven actions on tables in the reference folder (read, insert, delete). 

The results of this program can help you identify and determine how performance compares to previously metered criteria based on benchmarks and feedback from other customers’ production infrastructures. 


  PU8 guide : To help in the qualification of an infrastructure regardless of its nature : physical or virtual, mono or multi-tier, Oracle or SQL Server, Unix-Linux or Windows, etc., the Sage editor can provide a program for measure the performance of its Software application to carry 7 actions in the database of the reference folder (read, write, delete).


Notes applicable to all X3 versions

  • This benchmark tool needs to be executed against the "X3" folder.
  • It's better to run this tool on a quiet system (e.g. no interactive users or batch jobs running) in order to get a meaningful result
  • This tool tests X3 core between runtime and DB only, there is no interaction with Syracuse, MongoDB nor Elastic Search or any other SAFE X3 Component

Version 6, 7, 8, 9 and 11

  • Note: ZX3IOBENCH_V2 is for V6 or older. ZX3IOBENCH_V2.6 Is for V7 and later
  • You can comment out the adxftl = line if you are in a V6 environment prior to P29 where adxftl is forced.
  1. Attached is the performance measurement tool for Sage X3.
  2. Copy the attached file to your X3\TRT directory.
  3. Switch to X3 folder.
  4. Open (ADOTRT) Development, Scripts dictionary, Scripts, Script editor.
  5. Open the script.
  6. Click Compile.
  7. Open (EXETRT) Development, Utilities, Miscellaneous, Run processes.
  8. Enter the script name.
  9. Click OK.
  10. The script would run and you can compare the legacy timing at the end of the produced log.


Version 12 up to and including patch 24

  1. Login as an ADMIN user and connect to X3 folder
  2. Navigate to Development, Miscellaneous, Run Processes
  3. Script: enter "AIOBENCH" and "OK" to continue
  4. A report will be presented once the process has completed

Version 12 patch 25 and above

  1. Login as an ADMIN user
  2. Navigate to Development, Utilities, Verifications, Performance Index (AIOBENCH)
  3. Click "Execution" and "Yes" to continue
  4. A report will be presented once the process has completed

Version 12 patch 26 (2021R2)

See the Related Resources for Hotfixes to install on v12 patch 26 (2021R2)

  • Download Hotfix for Sage X3 v12.0.26 Performance Measurement Tool (AIOBENCH)
  • Download Hotfix for Sage X3 Warehousing v12.0.26 Performance Measurement Tool (AIOBENCH)

Interpretion of the results

The number that you need to pay attention to is the Legacy Index number, if this number is more than 200 for single-tier system or more than 300 seconds for multi-tier system which indicates your environment is not running in high performance, and if your system is virtualized and based on VMware, you can try attached suggestions.

Classification of results is shown in the online help

Image

DocLink: Download Hotfix for Sage X3 v12.0.26 Performance Measurement Tool (AIOBENCH)
DocLink: Download Hotfix for Sage X3 v12.0.26 Performance Measurement Tool (AIOBENCH)
DocLink: Download Hotfix for Sage X3 Warehousing v12.0.26 Performance Measurement Tool (AIOBENCH)
DocLink: Download Hotfix for Sage X3 Warehousing v12.0.26 Performance Measurement Tool (AIOBENCH)
DocLink: How to troubleshoot slow performance for Sage X3
DocLink: Virtualization best practice documentation obtained
Attachment: 210_20230425124339_ZX3IOBENCH_V2.6.src
Attachment: 461_20230425124339_ZX3IOBENCH_V2.src



Related Solutions

See the online help article "Performance Index"