List View portlet taking long time to appear
search cancel

List View portlet taking long time to appear


Article ID: 111007


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


We have a portlet on a List View in UMP, that is taking a long time (minutes) to appear but the other portlets in the same view appear much quicker. I have managed to grab the t-sql query that is used to generate the portlet and have noticed that there is an index hint in the query that forces the query to use a certain index. If I comment the index hint out of the query, the query returns data in seconds rather than minutes with the index hint in place. 

Below is an excerpt from the query:

       LEFT JOIN (SELECT qos_c2.table_id, qos_c2.source, qos_c2.origin,, SUM(qd_c2.samplevalue) AS samplevalue 
                      FROM s_qos_data qos_c2 JOIN 
                           RN_QOS_DATA_0202 qd_c2 
                             WITH (INDEX(RN_QOS_DATA_0202_idx1)) 
                             ON (qd_c2.table_id = qos_c2.table_id AND qd_c2.sampletime > @P0) 
                      WHERE ( qos_c2.qos = @P1  ) 
                      GROUP BY qos_c2.table_id, qos_c2.source, qos_c2.origin ,  
                  ) qos_c2
              ON qos_c2.source = s_qos_data.source AND qos_c2.origin = s_qos_data.origin AND = 

The query is Top 10 Interface Errors which uses QOS_INTERFACE_ERRORS_COUNT and the probe interface_traffic to output a chart with error counts over 1 hour & 24 hours


SQL Server 2014 SP1

Resolution resolves this issue

If you have this issue please raise a support case and refer to Defect DE369749