SQL Server: Benchmarking and Baselining [2012, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

SQL Server: Benchmarking and Baselining

Год выпуска: 2012
Производитель: pluralsight.com
Автор: Erin Stellato
Продолжительность: 03:20:45
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: 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.
[spoiler="Содержание"]
Introduction 00:14:38
Course Introduction 02:29
What is a Baseline? 02:51
What is a Benchmark? 02:09
Why Are They Important? 04:00
Who Needs to Capture This Information? 02:04
Course Structure 01:05

What, When, and Where 00:18:13
Introduction 03:15
Deciding What Data to Capture 01:47
Deciding What Data to Capture (2) 01:49
Deciding What Data to Capture (3) 01:39
Deciding When to Capture Data 03:52
Deciding How to Store and Retrieve Data 03:14
Summary 02:37

Performance Monitor 01:06:34
Introduction 01:51
Perfmance Monitor Pros, Cons, and Overhead 02:25
Use Performance Monitor When... 01:32
Using Performance Monitor in Real-Time 01:32
Demo: Performance Monitor 06:50
Counters to Capture 01:42
OS/Resource Counters to Capture 03:24
OS/Resource Counters to Capture (2) 02:01
OS/Resource Counters to Capture (3) 02:55
SQL Server Counters to Capture 02:45
SQL Server Counters to Capture (2) 03:16
SQL Server Counters to Capture (3) 02:28
SQL Server Counters to Capture (4) 03:24
Counter Collection 02:06
Data Collector Sets 01:26
Demo: Data Collector Sets 07:03
Processing Performance Monitor Data 01:30
Demo: relog 08:45
Processing Performance Monitor Data (2) 01:08
Demo: PAL 07:31
Summary 01:00

Capturing Queries 00:49:27
Introduction 01:59
SQL Trace 02:45
Demo: SQL Trace 06:40
Extended Events 02:36
Demo: Extended Events 04:31
When to Use SQL Trace vs. Extended Events 03:49
Clear Trace 03:07
Demo: Clear Trace 06:52
ReadTrace 01:40
Demo: ReadTrace 08:02
Benefits of Clear Trace vs. ReadTrace 02:44
Replaying Workloads 03:19
Summary 01:23

Using DMVs 00:42:33
Introduction 03:24
When to Use DMVs 02:15
Capturing DMV Data 01:33
DMVs to Consider for Data Capture 02:57
Demo: sys.dm_os_performance_counters 05:01
DMVs to Consider for Data Capture (2) 03:23
Demo: sys.dm_io_virtual_file_stats 04:17
DMVs to Consider for Data Capture (3) 02:52
Other Data You Can Capture 02:49
Demo: sys.configurations 04:09
WhoIsActive 01:57
Demo: WhoIsActive 06:48
Summary 01:08

Pulling It All Together 00:09:20
Introduction 00:53
Before You Start 02:39
Before You Start (2) 01:06
Data Options 02:05
Next Steps 01:42
Summary 00:55
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: WMV3, 1024x768, 15 fps, ~100 kbps
Аудио: WMA v2, 44100Hz, 128 kb/s, Stereo
[spoiler="Скриншоты"]

[/spoiler]