Baseline

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
    • http://www.sqlservercentral.com/articles/baselines/94657/
  • Back to Basics: Capturing Baselines on Production SQL Servers
    • http://www.sqlservercentral.com/articles/baselines/94656/
  • Capturing Baselines on SQL Server: Wait Statistics
    • http://www.sqlservercentral.com/articles/baselines/96270/
  • Capturing Baselines on SQL Server: Where’s My Space?
    • http://www.sqlservercentral.com/articles/baselines/96059/
• SQLskills – Paul Randal
  • Make life easier on yourself, get a baseline!
    • http://www.sqlskills.com/blogs/paul/make-life-easier-on-yourself-get-a-baseline/
• simple-talk – Louis Davidson
  • Baselining with SQL Server Dynamic Management Views
    • https://www.simple-talk.com/content/print.aspx?article=1828
• SQL Server Central
  • Guy Glantser
    • Monitor Query Statistics
      • http://www.sqlservercentral.com/blogs/guy-glantser/2015/02/26/monitor-query-statistics/
  • Robert Virag
    • Comprehensive Baseline Collector Solution
      • http://www.sqlservercentral.com/articles/Baseline/115254/
    • Baseline Collector Solution V2
      • http://www.sqlservercentral.com/articles/Baseline/126578/
    • How to Install and Configure Baseline Collector Solution V2
      • http://www.sqlservercentral.com/articles/Baseline/132034/
• Brent Ozar
  • Jes Schultz
    • “It’s Slow” is not a metric
      • https://www.brentozar.com/archive/2015/02/slow-not-metric/
  • Brent Ozar
    • SQL Server Perfmon (Performance Monitor) Best Practices
      • https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

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”:
        • http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit#
      • Presentation Materials:
        • http://www.pass.org/DesktopModules/OratorData/API/SessionMaterial/Download?id=10735&type=2
    • Baseline Basics: Where to Start, What You Need
      • Filter using “Baseline”:
        • http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit
      • Presentation Materials:
        • http://www.pass.org/DesktopModules/OratorData/API/SessionMaterial/Download?id=368&type=2

Baseline Articles from SQL Tool Providers:

• Redgate:
  • Jonathan Allen – Getting Baseline and performance stats – the easy way:
    • https://www.red-gate.com/simple-talk/blogs/getting-baseline-and-performance-stats-the-easy-way/
• SentryOne:
  • Kevin Kline – PERFORMANCE BASELINES and BENCHMARKS FOR MICROSOFT SQL SERVER
    • https://www.sentryone.com/white-papers/performance-baselines-and-benchmarks-for-microsoft-sql-server?ad=201503-sql-pass-white-paper-baselines&ad=201503-sql-pass-white-paper-baselines

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)