SQL Server: Introduction to Extended Events [2012, ENG] torrent

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

SQL Server: Introduction to Extended Events

Год выпуска: 2012
Производитель: pluralsight.com
Автор: Jonathan Kehayias
Продолжительность: 05:00:29
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: Extended Events were added in SQL Server 2008 as a method of performing analysis and troubleshooting of SQL Server, with the ability to troubleshoot scenarios that have never been possible before. SQL Trace has finally been deprecated in SQL Server 2012 and so it is now imperative that developers and DBAs learn how to use Extended Events. This course explains the architecture of Extended Events, and how to create and manage event sessions, using events, actions, predicates, and basic targets. It then gives comprehensive coverage of the Management Studio UI for Extended Events that was added in SQL Server 2012, as well as the freely-available SSMS add-in that Jonathan wrote for SQL Server 2008 and 2008R2. The course ends by presenting some common troubleshooting scenarios that can be easily accomplished using Extended Events. It is perfect for those with no experience of Extended Events, those who are new to the Extended Events UIs and those with some experience but who want to solidify their understanding of Extended Events and how to use them. The information in the course applies to all versions from SQL Server 2008 onwards.
[spoiler="Содержание"]
Introduction 00:08:52
Introduction 01:20
What are Extended Events? 01:56
Why Replace SQL Trace 02:17
The Extended Events Solution 01:54
Course Structure 01:25

Extended Events Architecture 00:12:59
Introduction 01:16
Extended Events Engine 02:59
Event Sessions 01:37
Extended Events Architecture 01:07
Event Execution Lifecycle 01:53
Event Session Isolation 02:01
Dispatching 01:07
Summary 00:59

Extended Events Objects 00:44:40
Introduction 01:07
Packages 01:34
Demo: Packages 03:06
Events 02:29
Demo: Events 06:08
Predicates 03:26
Demo: Predicates 04:05
Actions 02:15
Demo: Actions 02:31
Targets 03:31
Demo: Targets 05:03
Types and Maps 01:42
Demo: Types and Maps 03:30
Metadata Catalog Views 02:39
Summary 01:34

SQL Server 2012 UI Integration 01:10:46
Introduction 02:04
New Event Session Wizard 01:51
Demo: New Event Session Wizard 05:52
New Session Dialog 02:08
Demo: New Session Dialog 06:55
Using Templates 01:18
Default Templates (1) 01:14
Demo: Count Query Locks 04:01
Default Templates (2) 01:19
Demo: Query Detail Sampling 03:01
Default Templates (3) 01:09
Demo: Query Wait Statistic 03:49
Default Templates (4) 02:40
Demo: Activity Tracking 04:18
Custom Templates 01:13
Demo: Using Templates 04:30
Viewing Target Data 01:57
Demo: Viewing Target Data 01:39
Customizing the Data View 02:59
Demo: Customizing the Data View 04:35
Live Data Viewer 01:58
Demo: Live Data Viewer 04:19
Exporting the Event Data 01:39
Demo: Exporting the Event Data 02:51
Summary 01:27

SQL Server 2008 SSMS Add-in 00:19:51
Introduction 01:28
Demo: Installing the Add-in 01:46
Metadata Viewer 01:10
Demo: Metadata Viewer 01:40
Session Editor Dialog 01:05
Demo: Session Editor 04:34
Target Data Viewer 01:25
Demo: Target Data Viewer 02:31
Add-in Options 00:56
Demo: Add-in Options 02:36
Summary 00:40

Defining Event Sessions 00:27:32
Introduction 01:24
Event Session Requirements 01:13
Demo: Event Session Requirements 02:40
Basic Predicates 02:11
Demo: Predicate Definitions 04:02
Understanding and Planning for Short Circuiting 02:20
Demo: Writing Predicates to Short Circuit 05:01
Adding Data with Actions 01:46
Demo: Using Actions 04:48
Summary 02:07

Event Session Management 00:32:44
Introduction 01:13
Event Session DDL Commands 01:48
Creating an Event Session 02:08
Modifying an Event Session 01:14
Demo: Event Session DDL 03:10
Event Session Management 01:40
Demo: Event Session Management Concepts 07:29
Session Definition Views 01:16
Demo: Session Definition Views 04:06
Active Session DMVs 01:59
Demo: Active Session DMVs 05:00
Summary 01:41

Basic Targets 00:42:28
Introduction 02:01
ring_buffer Target 02:25
Demo: ring_buffer Target 02:14
ring_buffer Target Options 02:11
Demo: ring_buffer Target Options 04:32
ring_buffer XML Output 01:27
Demo: ring_buffer XML Output 02:40
Event XML 02:48
Demo: Event XML 03:37
event_file Target 02:05
Demo: event_file Target 02:01
event_file Target Options 02:11
Demo: event_file Target Options 02:21
Reading event_file Data With Transact-SQL 01:54
Demo: Using sys.fn_xe_file_target_read_file 06:45
Summary 01:16

Basic Troubleshooting Scenarios 00:40:37
Introduction 01:36
Identifying Deadlock Issues 02:51
Demo: Identifying Deadlock Issues 05:09
Identifying Blocking Issues 01:49
Demo: Identifying Blocking Issues 03:41
Identifying Recompile Issues 02:11
Demo: Identifying Recompile Issues 05:22
Identifying When Errors Occur 02:20
Demo: Identifying When Errors Occur 06:02
Tracking Session-Level Waits 01:33
Viewing Historical System Health 03:05
Demo: Historical System Health 03:27
Summary 01:31
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: WMV3, 1024x768, 15 fps, ~125 kbps
Аудио: WMA v2, 44100Hz, 128 kb/s, Stereo
[spoiler="Скриншоты"]

[/spoiler]