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

SQL Server: Benchmarking and Baselining

Learn how to benchmark a SQL Server instance and create a performance baseline to compare against for simplified troubleshooting, applicable for developers, DBAs, and anyone who uses SQL Server 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