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 DWH - full load performance on various tables

book

Article ID: 209400

calendar_today

Updated On:

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