MSSQL Load DWH - full load performance on various tables

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

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, that could not be reproduced in house. Improvements have been added to Clarity 16.0 that should address this slowness

Additional Information

See also: Load DWH job frequently reported issues