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
Clarity PPM SaaSClarity PPM On Premise
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)