MSSQL - Load Data Warehouse Full Load job performance problem on large dataset
Article ID: 130147
Updated On:
Products
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
Our Load Data Warehouse Full Load is taking long time (SQL Server only)
STR:
1. On a large MSSQL customer database - only reproducible on large datasets
2. Make sure all jobs are Paused on this environment
3. Run Load Data Warehouse - Full Load - note it runs for 250+ minutes
Expected results: Load Data Warehouse - Full to take a smaller amount of time
Actual Results: Load Data Warehouse - Full takes 280-300 minutes for the customer, big majority of which is on DWH_RES_PERIOD_FACTS (if you check the timings in DWH_GATHER_METRICS_V)
STR:
1. On a large MSSQL customer database - only reproducible on large datasets
2. Make sure all jobs are Paused on this environment
3. Run Load Data Warehouse - Full Load - note it runs for 250+ minutes
Expected results: Load Data Warehouse - Full to take a smaller amount of time
Actual Results: Load Data Warehouse - Full takes 280-300 minutes for the customer, big majority of which is on DWH_RES_PERIOD_FACTS (if you check the timings in DWH_GATHER_METRICS_V)
Environment
Affects Clarity versions 15.3 and higher
Resolution
This is DE40179, resolved in 15.6
Feedback
Yes
No
Powered by
