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

book

Article ID: 130147

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application 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)

Environment

Affects Clarity versions 15.3 and higher

Resolution

This is DE40179, resolved in 15.6