Info: Improving Performance for Viewing Logs

Applies To:

Venafi Director 8 – 11

&

Venafi Trust Protection Platform 14.1

Summary:

An extremely large amount of logs can slow down your access of the logging in the Venafi software. Extremely poor Network or database connection performance can slow down your access of the logging in the Venafi software.

These both can slow down or even time out viewing of your logging. With the SQL below, we can build an index that should help alleviate some of this logging stress.

More Info:

• If you are running Microsoft SQL:

CREATE NONCLUSTERED INDEX [log_component] ON [dbo].[log] ([Component]);

UPDATE STATISTICS [dbo].[Log];

• If you are running Oracle SQL:

CREATE INDEX log_component ON LOG (NLSSORT(COMPONENT, 'NLS_SORT=BINARY_CI'));

NOTE: If you are trying on Oracle, please remember that the statistics need to be run after the index creation.

In Director 8x your update on statistics will look something like this:

ANALYZE TABLE STORE_VAULT COMPUTE STATISTICS;

ANALYZE TABLE STORE_ASSOCIATIONS COMPUTE STATISTICS;

ANALYZE TABLE STORE_ACCESS COMPUTE STATISTICS;

ANALYZE TABLE RIGHTS COMPUTE STATISTICS;

ANALYZE TABLE LOG COMPUTE STATISTICS;

ANALYZE TABLE DISCOVERY_RESULTS COMPUTE STATISTICS;

ANALYZE TABLE DISCOVERY_JOBS COMPUTE STATISTICS;

ANALYZE TABLE CONFIG_OBJECTS COMPUTE STATISTICS;

ANALYZE TABLE CONFIG_CONTAINS COMPUTE STATISTICS;

ANALYZE TABLE CONFIG_POLICIES COMPUTE STATISTICS;