Follow

Log Server Performance Issues

Applies To:

Version 16.2

Symptom

The Log Server experiences performance degradation while processing large volumes of log entries, for example after running large Discovery jobs.

Cause

A large amount of log data fragments the database indexes and causes slow log view performance,

Solution

Use the following Microsoft SQL Server commands for re-indexing logging tables: 

ALTER INDEX ALL ON DAL_T_LOG_LOG_MESSAGE REBUILD WITH (FILLFACTOR = 50);
ALTER INDEX ALL ON DAL_T_LOG_LOG_COMP REBUILD WITH (FILLFACTOR = 90);
ALTER INDEX ALL ON DAL_T_LOG_LOG_DATA REBUILD WITH (FILLFACTOR = 50);
ALTER INDEX ALL ON DAL_T_LOG_LOG_PARAMS REBUILD WITH (FILLFACTOR = 50);
ALTER INDEX ALL ON DAL_T_LOG_LOG_SOURCE_IP REBUILD WITH (FILLFACTOR = 90);

UPDATE STATISTICS DAL_T_LOG_LOG_COMP;
UPDATE STATISTICS DAL_T_LOG_LOG_DATA;
UPDATE STATISTICS DAL_T_LOG_LOG_PARAMS;
UPDATE STATISTICS DAL_T_LOG_LOG_SOURCE_IP;
UPDATE STATISTICS DAL_T_LOG_LOG_MESSAGE;

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk