Baseline Template (Example)
| SQL_ID | Date | Avg Elapsed (s) | Avg Rows | Avg Buff Gets | Avg Disk Reads | Plan Hash |
|---|---|---|---|---|---|---|
| abcd1234 | 2025-05-02 | 2.8 | 14,200 | 28,000 | 64 | 872349876 |
Tip:
Automate this for key queries with a scheduled job.If you care about a query, baseline it. You’ll thank yourself later when something changes—and you need to prove it.