Here is a curated list of Baseline related links that I recommend visiting:
Baseline Articles:
- Erin Stellato’s Articles
- 5 Reasons You Must Start Capturing Baseline Data
- Back to Basics: Capturing Baselines on Production SQL Servers
- Capturing Baselines on SQL Server: Wait Statistics
- Capturing Baselines on SQL Server: Where’s My Space?
- SQLskills – Paul Randal
- Make life easier on yourself, get a baseline!
- simple-talk – Louis Davidson
- Baselining with SQL Server Dynamic Management Views
- SQL Server Central
- Guy Glantser
- Monitor Query Statistics
- Robert Virag
- Comprehensive Baseline Collector Solution
- Baseline Collector Solution V2
- How to Install and Configure Baseline Collector Solution V2
- Guy Glantser
- Brent Ozar
- Jes Schultz
- “It’s Slow” is not a metric
- Brent Ozar
- SQL Server Perfmon (Performance Monitor) Best Practices
- Jes Schultz
Baseline Presentations:
- Professional Association for SQL Server (requires free login)
- PASS Summit Recordings
- The Day After Tomorrow: Why You Need to Baseline
- Filter using “Baseline”:
- Presentation Materials:
- Baseline Basics: Where to Start, What You Need
- Filter using “Baseline”:
- Presentation Materials:
- The Day After Tomorrow: Why You Need to Baseline
- PASS Summit Recordings
Baseline Articles from SQL Tool Providers:
- Redgate:
- Jonathan Allen – Getting Baseline and performance stats – the easy way:
- SentryOne:
- Kevin Kline – PERFORMANCE BASELINES and BENCHMARKS FOR MICROSOFT SQL SERVER
Baseline Videos:
PASS DBAFundamentals Virtual Chapter
- SQL Server Performance Monitoring & Baselining
PASS PowerShell Virtual Chapter
- Maintain SQL Server Performance Baseline with PowerShell
PASS Women In Technology Virtual Chapter
- SQL Server Take Over Establishing a Baseline with Lowry Kozlowski
SQL Workbooks
- Collect and Baseline Wait Statistics (Dear SQL DBA Episode 14)