eG Database Tables Test

This test monitors the tables in the eG database and turns the spotlight on the following:

  • Large sized tables in terms of the volume of data they store;
  • Tables with too many rows of data;
  • Tables that are badly structured - i.e., tables without index or tables without primary key

Target of the test : The eG Manager

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for the eG manager being monitored

Configurable parameters for the test
Parameter Description

Test period

How often should the test be executed .

Host

The host for which the test is to be configured.

Port

The port number at which the specified host listens.

JMX Remote Port

Here, specify the port at which the JMX listens for requests from remote hosts. In the <EG_MANAGER_INSTALL_DIR>\manager directory (on Windows; on Unix, this will be the /opt/egurkha/manager directory) of the eG manager, you will find a management.properties file. Set the port defined against the com.sun.management.jmxremote.port parameter of the file as the JMX Remote Port.

User, Password, and Confirm Password

By default, JMX requires no authentication or security. Therefore, the User, Password , and Confirm Password parameters are set to none by default.

JNDIName

The JNDIName is a lookup name for connecting to the JMX connector. By default, this is jmxrmi. If you have registered the JMX connector in the RMI registry using a different lookup name, then you can change this default value to reflect the same.

JMX Provider

This test uses a JMX Provider to access the MBean attributes of the eG manager and collect metrics. Specify the package name of this JMX Provider here. By default, this is set to com.sun.jmx.remote.protocol.

Timeout

Specify the duration (in seconds) for which this test should wait for a response from the eG manager. If there is no response from the eG manager beyond the configured duration, the test will timeout. By default, this is set to 240 seconds.

Maximum Table Size

Specify the maximum size limit (in KB) that a table should exceed in order to be counted as a high volume table.

Maximum Table Size

Specify the minimum size limit (in KB) that a table should fall below in order to be counted as a low volume table.

Maximum Row Size

This test reports all tables with more number of rows than the row limit specified here as Tables with many rows.

Minimum Row Size

This test counts reports tables with less number of rows than the row limit specified here as Tables with few rows.

Detailed Diagnosis

To make diagnosis more efficient and accurate, the eG Enterprise suite embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option.

The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled:

  • The eG manager license should allow the detailed diagnosis capability
  • Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.
Measurements made by the test
Measurement Description Measurement Unit Interpretation

Database Size

Indicates the total size of the eG database.

MB

 

Total tables

Indicates the total number of tables that currently exist in the eG database.

Number

 

Default tables

Indicates the number of default tables in the eG database.

 

Number

 

Dynamic tables

Indicates the number of dynamic tables currently present in the eG manager database.

 

Dynamic tables are typically a set of virtual tables used to record current database activity.

Tables without primary key

Indicates the number of tables without a primary key.

Number

The purpose of a primary key is to uniquely identify each record in a table.

An index on the other hand, is an alphabetical listing of the terms found on database records and the number of records on which the terms are found.

A database table can survive without a primary key or an index, but this deters the whole purpose of a database: the easy retrieval of information.

To know which tables do not have an index or a primary key, use the detailed diagnosis of this measure.

Tables without index

Indicates the number of tables without an index.

Number

Newly created tables

Indicates the number of tables created in the eG database since the last measurement period.

Number

New tables will be created in the eG database as and when new components are monitored in the environment.

Active sessions

Indicates the number of active sessions to the eG backend.

Number

This is a good indicator of the current load on the eG database. Use the detailed diagnosis of this measure to view the hosts from which the active sessions originated. 

Inactive sessions

Indicates number of currently inactive sessions to the eG database.

Number

Open, but inactive sessions are serious resource drains. Use the detailed diagnosis of this measure to view the hosts that are responsible for initiating the inactive sessions, determine the reason for the inactivity, and if found necessary, terminate the sessions in order to protect the database from abuse.

Tables with highest volume of data

Indicates the number of tables that contain a high data volume.

Number

This measure value includes all tables that are of a size greater than the Maximum Table Size configured for this test.

Use the detailed diagnosis to identify the large sized tables.  

Tables with lowest volume of data

Indicates the number of tables that contain a low data volume.

Number

This measure value includes all tables that are of a size lesser than the Minimum Table Size configured for this test.

Use the detailed diagnosis to identify the small sized tables.  

Tables with many rows

Indicates the number of tables with many rows.

Number

This measure value includes all tables with more number of rows than the Maximum Row Size configured for this test.

Use the detailed diagnosis to identify the tables with too many rows.  

Tables with few rows

Indicates the number of tables with few rows.

Number

This measure value includes all tables with less number of rows than the Minimum Row Size configured for this test.

Use the detailed diagnosis to identify the tables with only a few rows.  

The detailed diagnosis of the Tables with highest volume of data measure displays all the tables with high data volume, and reports the current size of each table.

DDtableswithhighestvolume

Figure 1 : The detailed diagnosis of the Tables with highest volume of data measure

The detailed diagnosis of the Tables with lowest volume of data measure displays all the tables with low data volume, and reports the current size of each table.

DDtableswithlowestvolumeofdata

Figure 2 : The detailed diagnosis of the Tables with lowest volume of data measure

The detailed diagnosis of the Tables with many rows measure displays all the tables with many rows, and the number of rows in each table. 

DDtableswithmanyrows

Figure 3 : The detailed diagnosis of the Tables with many rows measure

The detailed diagnosis of the Tables with few rows measure displays all the tables with few rows, and the number of rows in each table. 

DDtableswithfewrows

Figure 4 : The detailed diagnosis of the Tables with few rows measure

The detailed diagnosis of the Tables without primary key measure displays all the tables that do not have any primary key. 

DDtableswithoutprimarykey

Figure 5 : The detailed diagnosis of the Tables without primary key measure

The detailed diagnosis of the Tables without index measure displays all the tables that do not have any index. 

DDtablewithoutindex

Figure 6 : The detailed diagnosis of the Tables without index measure