Index recommendations for related event performance

Edit online

Improve indexes on the historical database.

Problem

  • The related events configuration is slow to run.
  • The Related Events Details page is slow to load.

Resolution

The database administrator is responsible for constructing and maintaining appropriate indexes on the historical database.

As a database administrator, review the filter fields for the reports as a basis for an index and review if an index is necessary for the Identity fields. Also, index the Timestamp field, which you can set in the Event Analytics Configuration wizard.

For the Related Events Details page, create an index on the SERVERSERIAL and SERVERNAME columns on the historical database table. For an example on a Db2® historical database, see the following command: 
CREATE INDEX myServerIndex ON Db2INST1.REPORTER_STATUS (SERVERSERIAL, SERVERNAME);