Global Dictionary Fill Level Test

Dictionaries are used for compressed indexes for accelerator technologies like BI accelerator. A Global directory stores the data in the physical tables that translate values into index IDs. This directory would assign consecutive ID numbers, since renumbering the complete global dictionary below a newly inserted value would be infeasible considering the huge size of the dictionary. However, the dictionary is sorted to allow searches in logarithmic time and to perform range searches. If the global dictionary is near full, then, data search would take too long to complete which may result in performance bottleneck. Therefore, it is necessary to constantly keep a vigil on the size and fill level of the Global dictionary. This is where the Global Dictionary Fill Level test helps!

This test reports the maximum size allocated to the global dictionary for each index server and the current size of the global dictionary.

Target of the test : A SAP TREX

Agent deploying the test : An internal agent

Outputs of the test : One set of results for each index server: Global dictionary of the target SAP TREX server that is to be monitored

Configurable parameters for the test
  1. TEST PERIOD - How often should the test be executed
  2. Host – The host for which the test is to be configured.
  3. PORT - Specify the port at which the specified HOST listens.
  4. TREX DIRECTORY - Specify the full path to the SAP TREX instance that is to be monitored for e.g., the location can be specified as D:\usr\sap\TRX\TRX01.
  5. TIMEOUT - Specify the duration (in seconds) beyond which this test should time out in the TIMEOUT text box. The default is 120 seconds.
Measures made by the test:
Measurement Description Measurement Unit Interpretation

Current size:

Indicates the current size of this global dictionary.

GB

A value close to the Maximum size measure is a cause of concern. Administrators should either consider increasing the size of the global dictionary or clean up the global dictionary to remove unwanted or outdated entries.

Percentage current size:

Indicates the current size of this global dictionary, in percentage.

Percent

 

Maximum size:

Indicates the maximum size allocated to this global dictionary.

GB