Application Chart widget slow when using All Computers

Problem

You have created a location that contains all unmapped subnets. When you select that location instead of All Computers in the Application Chart widget, the widget refreshes very slowly.

Cause

The database tables that hold the data for the widget are missing an index for this kind of query.

Solution

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