Performance issues generating views in Metric Viewer

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

While  trying to fetch 5 mins interval performance data, getting metric view but not able to export the report. For same number of servers group with same time interval  can export the data but sometimes unable to export the report.

While fetching group of server reports the entire server values are missing but when trying for a single server, able to see the data.

Environment

Release: DX UIM 23.4.4

Component: OC Metric viewer

Resolution

PFA the optimized version of the stored procedure, metricReportData_1_final_enhanced.sql, which addresses the performance concerns previously discussed.

 

Key Improvements:

Set-Based Logic: I have replaced legacy row-by-row processing with high-performance set-based operations (Recursive CTEs and Window Functions) to significantly reduce execution time on large datasets.

Enhanced Instrumentation: New granular logging has been integrated into the procedure. This allows us to track the duration of each internal logic block (interpolation, aggregation, etc.) in real-time.

To monitor the performance of the various execution flows, you can run the following query:

SQL

SELECT * FROM tbnlogging ORDER BY starttime DESC;

 

These optimizations are slated for inclusion in future releases