Part 4 – Performance Tuning Phase

1. Intro
2. Original
   State
3. Transitional
   Architectures
4. Target Future
   State
5. Tuning
   Phase
6. Summary

A performance layer was necessary to insure sub-second response from queries and reports running against years of historical data delivering critical KPIs.

Frequency of performance layer rebuilding occurred nightly in addition to rebuild as needed triggered from MS Access application to Logic App to SQL Server stored procedures.

• Intro
• Original State
• Transitional Architectures
• Target Future State
• Tuning Phase
• Summary