RDBMS Diagnostic

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.

Please note that this module will not be installed in the HAS console. Once download please unzip the package, then launch utility

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

• Add Connection Parameter to set 'integratedSecurity=true;' to support windows authentication for SQL Server. 
• Add Compatibilty level test of SQL Database
  
  
  The compatibility level and engine version are correct:
  

   Base compatibility level:  160

   Engine version: 16.0.1050.5
   
  
  
  The compatibility level and engine version is incorrect:
  

   Base compatibility level:  120

   Engine version: 16.0.1050.5

Changed

• N/A

Fixed

• N/A

Removed

• N/A