Does This Look Weird? The Importance of Baselining

Summary

Collect a baseline for a SQL Server instance and analyze it against current stats to tell if something abnormal is going on with your SQL Server.

Abstract

How do you know when your server is on fire?  Without a set of known-good measurements to compare against, you don’t.  This session will show you how to capture a performance baseline for a SQL Server instance and help you decide what to capture, and where to store it. Finally we will put it all together by walking through a scenario using the captured baseline data to identify a problem.

Goals

1. Know what to capture for a baseline for a SQL Server instance.
2. How to capture a baseline for a SQL Server instance.
3. How to analyze current stats against an existing baseline.