DE59914 - MSSQL Load Data Warehouse - Full Load Performance on various tables

book

Article ID: 209400

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

Issue/Introduction

STEPS TO REPRODUCE:

  1. Run Load Data Warehouse job - Full on MSSQL

Expected Results: The job to run in a timely manner

Actual Results: The job takes 2-3 hours to complete

In the AUDIT_HISTORY table we see different culprits:
DWH_INV_PERIOD_FACTS Taking 1-1,5h
DWH_INV_TEAM_PERIOD_FACTS Taking from 20 min to 1h
DWH_RES_PERIOD_FACTS from 20 min to 50 min
DWH_FIN_TRANSACTION taking 20 to 30 min

Environment

Release : 15.8.1+

Component : CA PPM DATA WAREHOUSE

Resolution

This is DE59914, in review by Engineering