Application Chart widget slow when using All Computers
- Henrik Wendt
- Mikkel Knop
Owned by Henrik Wendt
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 articles