RDBMS Diagnostic

Utility that should be used before starting to use environments and repositories on an RDBMS. This utility runs several tests for which the results will be compared to some memorized values corresponding to a situation where HOPEX is likely to have close-to-optimum performances.

Summary

HOPEX RDBMS Diagnostic Utility
Utility that should be used before starting to use environments and repositories on an RDBMS. This utility runs several tests for which the results will be compared to some memorized values corresponding to a situation where HOPEX is likely to have close-to-optimum performances.

Key Features

• Test RDBMS Performance of your infrastucture.

Requirements

• N/A

Dependencies

• N/A

Documentation

Full documentatin available on HOPEX Documentation from MEGA Community

• Unzip the package, then launch RDBMS Diagnostic.bat
• Select the RDBMS type (SQL Server):

• Enter the connection information to the RDBMS storage that is the target for hosting the HOPEX data:
  • a database name for SQL Server 

• In order to have consistent times, the Expected Execution Time values were recorded after running the utility more than once and noticing that the values were stable.
• So to have results that can be considered valid, run the utility twice and consider the values of the 2nd run.

Here is an example of some test results:

Release Notes

New

• N/A

Changed

• N/A

Fixed

• N/A

Removed

• N/A