Running consistent benchmark tests to record the system's results is important when analyzing and tuning a system for system instability or performance issues. If a performance-related problem is logged and a request for help has been received, it is important to be able to determine if configuration and system changes have a measurable effect on improving performance.
The following details of the server-client configuration need to be recorded:
-
OS version
-
Processors
-
32 or 64-bit
-
Memory
The best way to gather this data is to use the HxGN SDx diagnostic tool, which is available from support.
You should gather additional information about the system database configuration by running a number of scripts on the database. While this process differs between Oracle and SQL databases, the basic information can be gathered with the diagnostic tool. A separate document with embedded scripts is available from support or the product center and explains the process for gathering this information.