Documentation / QueryStore Analyzer / Common Workflows
Work left-to-right: Overview → click the hot database → Queries → Execution Plan / Tuning Tips. Keep the Metric-in dropdown consistent (ms vs sec) so charts and tables match what you expect.

Typical Workflows

Daily Health Check (2 minutes)

  1. Open DBLense ? Connect ? Overview
  2. Set time range to "1 Day" ? Click Refresh
  3. Scan Database Execution Summary → check CPU % column for red highlights
  4. Switch to Database Execution Compare → any unusual spikes vs. yesterday?
  5. Run General Health Check in the Anomaly / Root Cause Detector tab

Investigating a Slow Application (5 minutes)

  1. Overview ? Database Execution Summary ? find the database with the highest CPU % or Total Duration
  2. Click the database name ? Databases page opens pre-filtered
  3. Sort Query Execution Summary by Avg Duration descending
  4. Click the worst query hash ? Queries page opens
  5. Check the Plan Summary scatter plot → do you see multiple plan clusters (plan regression)?
  6. Open Execution Plan tab ? look for Table Scans or Key Lookups with high cost
  7. Run Performance Tuning Tips ? get specific fix recommendations
  8. Copy the Enhanced Query ? test in SSMS

Post-Deployment Validation (3 minutes)

  1. Queries page ? select the affected database
  2. Open Execution Compare sub-tab
  3. Sort by "? Today" descending ? find queries running more or taking longer since the deployment
  4. Investigate any regression ? Execution Plan ? Tuning Tips

Index Optimization (5 minutes)

  1. Queries page ? select a database ? open Missing Indexes sub-tab
  2. Sort by Impact % descending ? copy the top CREATE INDEX statements
  3. Switch to Unused Indexes ? find indexes creating write overhead
  4. Cross-reference: don't create an index if a similar unused one already exists

Incident Root Cause Analysis (3 minutes)

  1. Overview ? Anomaly / Root Cause Detector tab
  2. Select the relevant symptom (e.g., High CPU Usage)
  3. Choose Past / Historical Issue ? set the time window to when the incident occurred
  4. Click Examine & Detect Root Cause
  5. Review findings sorted by impact ? copy root-cause SQL ? share with team