MSSQL Load DWH - 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

The Load Data Warehouse (DWH) job full is very slow on MSSQL, it takes a long time to complete

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 you 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 : CLARITY DATA WAREHOUSE

Resolution

This is DE59914, in review by Engineering

Additional Information

See also: Load DWH job frequently reported issues