ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

MSSQL - Load Data Warehouse Full Load job performance problem on large dataset


Article ID: 130147


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


Our Load Data Warehouse Full Load is taking long time (SQL Server only)

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)


Affects Clarity versions 15.3 and higher


This is DE40179, resolved in 15.6