Our next meeting will be on the third Wednesday of the month. We use EventBrite for registrations, so please register at http://adssug201301.eventbrite.com.
Our next meeting is: Wed, Jan 16 2013 12:00 to 14:00 in Adelaide.
The importance of baselines
When you experience a performance problem, how can you easily tell where the problem is without being able to compare against a known-good set of measurements?
In this session, Erin Stellato will demonstrate the need for baselines, and show how to create a performance baseline for a SQL Server instance, using tools such as Performance Monitor, DMVs, SQL Trace and Extended Events. Using benchmarking techniques she will explain and demonstrate how to solve a problem based on comparisons to baselines.
Speaker: Erin Stellato
Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 12 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery.
Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.
Download material about this presentation: Baselines_Adelaide.zip