Please enable Javascript, which is required for this site.
sqlserver-benchmarking

SQL Server: Benchmarking and Baselining

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? This course explains how to create a performance baseline for a SQL Server instance using benchmarking techniques. The course begins by exploring the reasons for benchmarking and baselining, along with how to decide what to capture, when and how often to capture it, and where to store it. It then explains how to use the Performance Monitor tool in detail, along with how to capture query information using SQL Trace and Extended Events, and then analyze that information using the free Clear Trace and ReadTrace tools. After that it describes and demonstrates the multitude of Dynamic Management Views that can be used to gather information about SQL Server, before ending with a summary that pulls all the modules together. This course is perfect for those with no experience of benchmarking and baselining, and those with some experience but who want to solidify their understanding of creating and using benchmarks and baselines. The information in the course applies to all versions from SQL Server 2005 onwards.

Authored by: Erin Stellato
Duration: 3h 20m
Level: Intermediate
Released: 10/19/2012
Features: Closed captions
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using:  {{getCurrentPlayerName()}}  [Change]
expand all | collapse all Progress Duration
This module is unavailableIntroduction
 You have not watched this Module. 00:14:38
Course Introduction
You have not watched this Clip. 02:29
What is a Baseline?
You have not watched this Clip. 02:51
What is a Benchmark?
You have not watched this Clip. 02:09
Why Are They Important?
You have not watched this Clip. 04:00
Who Needs to Capture This Information?
You have not watched this Clip. 02:04
Course Structure
You have not watched this Clip. 01:05
This module is unavailableWhat, When, and Where
 You have not watched this Module. 00:18:13
Introduction
You have not watched this Clip. 03:15
Deciding What Data to Capture
You have not watched this Clip. 01:47
Deciding What Data to Capture (2)
You have not watched this Clip. 01:49
Deciding What Data to Capture (3)
You have not watched this Clip. 01:39
Deciding When to Capture Data
You have not watched this Clip. 03:52
Deciding How to Store and Retrieve Data
You have not watched this Clip. 03:14
Summary
You have not watched this Clip. 02:37
This module is unavailablePerformance Monitor
 You have not watched this Module. 01:06:34
Introduction
You have not watched this Clip. 01:51
Perfmance Monitor Pros, Cons, and Overhead
You have not watched this Clip. 02:25
Use Performance Monitor When...
You have not watched this Clip. 01:32
Using Performance Monitor in Real-Time
You have not watched this Clip. 01:32
Demo: Performance Monitor
You have not watched this Clip. 06:50
Counters to Capture
You have not watched this Clip. 01:42
OS/Resource Counters to Capture
You have not watched this Clip. 03:24
OS/Resource Counters to Capture (2)
You have not watched this Clip. 02:01
OS/Resource Counters to Capture (3)
You have not watched this Clip. 02:55
SQL Server Counters to Capture
You have not watched this Clip. 02:45
SQL Server Counters to Capture (2)
You have not watched this Clip. 03:16
SQL Server Counters to Capture (3)
You have not watched this Clip. 02:28
SQL Server Counters to Capture (4)
You have not watched this Clip. 03:24
Counter Collection
You have not watched this Clip. 02:06
Data Collector Sets
You have not watched this Clip. 01:26
Demo: Data Collector Sets
You have not watched this Clip. 07:03
Processing Performance Monitor Data
You have not watched this Clip. 01:30
Demo: relog
You have not watched this Clip. 08:45
Processing Performance Monitor Data (2)
You have not watched this Clip. 01:08
Demo: PAL
You have not watched this Clip. 07:31
Summary
You have not watched this Clip. 01:00
This module is unavailableCapturing Queries
 You have not watched this Module. 00:49:27
Introduction
You have not watched this Clip. 01:59
SQL Trace
You have not watched this Clip. 02:45
Demo: SQL Trace
You have not watched this Clip. 06:40
Extended Events
You have not watched this Clip. 02:36
Demo: Extended Events
You have not watched this Clip. 04:31
When to Use SQL Trace vs. Extended Events
You have not watched this Clip. 03:49
Clear Trace
You have not watched this Clip. 03:07
Demo: Clear Trace
You have not watched this Clip. 06:52
ReadTrace
You have not watched this Clip. 01:40
Demo: ReadTrace
You have not watched this Clip. 08:02
Benefits of Clear Trace vs. ReadTrace
You have not watched this Clip. 02:44
Replaying Workloads
You have not watched this Clip. 03:19
Summary
You have not watched this Clip. 01:23
This module is unavailableUsing DMVs
 You have not watched this Module. 00:42:33
Introduction
You have not watched this Clip. 03:24
When to Use DMVs
You have not watched this Clip. 02:15
Capturing DMV Data
You have not watched this Clip. 01:33
DMVs to Consider for Data Capture
You have not watched this Clip. 02:57
Demo: sys.dm_os_performance_counters
You have not watched this Clip. 05:01
DMVs to Consider for Data Capture (2)
You have not watched this Clip. 03:23
Demo: sys.dm_io_virtual_file_stats
You have not watched this Clip. 04:17
DMVs to Consider for Data Capture (3)
You have not watched this Clip. 02:52
Other Data You Can Capture
You have not watched this Clip. 02:49
Demo: sys.configurations
You have not watched this Clip. 04:09
WhoIsActive
You have not watched this Clip. 01:57
Demo: WhoIsActive
You have not watched this Clip. 06:48
Summary
You have not watched this Clip. 01:08
This module is unavailablePulling It All Together
 You have not watched this Module. 00:09:20
Introduction
You have not watched this Clip. 00:53
Before You Start
You have not watched this Clip. 02:39
Before You Start (2)
You have not watched this Clip. 01:06
Data Options
You have not watched this Clip. 02:05
Next Steps
You have not watched this Clip. 01:42
Summary
You have not watched this Clip. 00:55