CMS Snapshot Analysis - Run Metrics Calculation - Performance issue - Run metrics Calculation step is hanging on a DDL file (SQL Analyzer)
Purpose (problem description)
The purpose of this page is to explain how to deal with hanging issues when running the Metrics Calculation step on a DDL file, after a SQL Analyzer analysis
Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ✅ |
| Microsoft SQL Server | ✅ |
| CSS3 | ✅ |
| CSS2 | ✅ |
Step by Step scenario
- Run the Analysis (At application level or Analysis Unit Level)
- After the Execution Unit has been analyzed, we note that the Run Metrics Calculation step never ends.
Action Plan
In such a SQL Analyzer analysis we often have only one file or a few files containing all the code, so we cannot afford to apply the dichotomy process. Some metrics are particularly long to process, for example “Avoid using SQL queries inside loops”. Deactivating them may be an option.
Edit file
\com.castsoftware.sqlanalyzer-x.y.z\configuration\Languages\SQL\SQLCastMetrics.xml Comment-out the sectionfor metric “Avoid using SQL queries inside loops” like shown below :
3. Relaunch Analysis
4. If you do not find the information you are looking for or solution for your problem,contact [CAST Technical Support](https://help.castsoftware.com/hc/en-us/articles/204189137-How-to-contact-CAST-Technical-Support) with [Relevant Input](/export-v2/tg/technical-guides/technical-guides-by-cast-aip-component/cms-snapshot-analysis-component/cms-snapshot-analysis-run-metrics-calculation/cms-snapshot-analysis-run-metrics-calculation-performance-issue/). CAST Technical Support will reproduce the issue
**Notes/Comments**
Ticket # 13498
**Related Pages**