/
Application Chart widget slow when using All Computers

Application Chart widget slow when using All Computers

Owned by Henrik Wendt
Last updated: Sept 10, 2020 by Mikkel Knop

Problem

Created an All Locations and added all unmapped subnets, now selecting All Locations instead of All Computers, the widget refresh rate is very slow.

Cause

There is missing an index on the table holding the data needed.

Solution/Workaround

Add the two indexes below. Be aware that you will see a relatively large increase in the disk space used to hold the tables.

CREATE NONCLUSTERED INDEX [agent_traffic_aggr_idx3]
ON [pguard].[agent_traffic_aggr_monitored] ([protocol_id],[ip_address],[port],[timestamp])
INCLUDE ([h1],[h10],[h2],[h3],[h4],[h5],[h6],[h7],[h8],[h9],[num_clients],[received_bytes],[received_trains],[sent_bytes],[sent_trains],[total_response_time],[process_name]) ON pguard_indx_big
GO

CREATE NONCLUSTERED INDEX [agent_traffic_aggr_unmonitored_idx3]
ON [pguard].[agent_traffic_aggr_unmonitored] ([group_id],[protocol_id],[port],[timestamp])
INCLUDE ([h1],[h10],[h2],[h3],[h4],[h5],[h6],[h7],[h8],[h9],[num_clients],[received_bytes],[received_trains],[sent_bytes],[sent_trains],[total_response_time],[process_name]) ON pguard_indx_big
GO

Related content