Application Chart widget slow when using All Computers

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.

Note

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 articles

• Page:

  Application Chart widget slow when using All Computers