Inspired by Brent Ozars Blog post http://www.brentozar.com/archive/2014/12/whos-allowed-add-indexes-isv-apps/ I will start this series.
It will consist of:
- Capture the workload
Capturing a typical workload during business hours.
- Diagnosis and Doing with “sp_BlitzIndex™”
Diagnose and Delete/Alter/Add Indexes with the help of Brent Ozars “sp_BlitzIndex™”.
- Diagnosis and Doing with “Find Key Lookups in Cached Plans”
Diagnose and Alter/Add Indexes with the help of Kendal van Dykes “Find Key Lookups in Cached Plans”.
- Setup Distributed Replay
Setup a SQL Server Instance with Distributed Replay.
- Replay the workload
Replay the captured workload against a backup first taken before capturing the first workload.
- Analysis of Performance Improvements
Analyze two captured workloads with the help of Qure Analyzer.
- Analysis with Chrome Developer Tools.
Load the ISV app in Chrome and make use of the Developer Tools to measure the response times of the Database Server.
- Subjective measurements
Let human beings test the improved app.
Hope to keep you as readers,