Azure SQL Database: Diagnosing Performance Issues with DMVs [2019, ENG] torrent

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

Azure SQL Database: Diagnosing Performance Issues with DMVs

Год выпуска: 2019
Производитель: Pluralsight
Сайт производителя: www.Pluralsight.com
Автор: Glenn Berry
Продолжительность: 1h 30m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Субтитры: Есть
Описание: Learn how to easily query Azure SQL Database for performance and configuration information to help identify and fix issues that can affect performance and stability. This course is applicable to anyone responsible for Azure SQL Database.

Научись запросам базы данных Azure SQL на тему производительности и конфигурации, исправляй проблемы.
[spoiler="Содержание"]
Course Overview 1m 25s
Course Overview 1m 25s
Introduction 5m 26s
Introduction and DMV Queries 1m 39s
Diagnosing Issues and Benefits of DMV Queries 1m 59s
Course Details and Module Summary 1m 47s
Diagnosing Database-level Configuration Issues 15m 49s
Introduction and Database Properties 2m 25s
Demo: Database Properties 1m 39s
File Sizes and Space 58s
Demo: File Sizes and Space 47s
Database-scoped Configurations 1m 29s
Demo: Database-scoped Configurations 1m 0s
Table Properties 48s
Demo: Table Properties 46s
Query Store Options 1m 30s
Demo: Query Store Options 58s
Automatic Tuning Options 1m 38s
Demo: Automatic Tuning Options 1m 13s
Module Summary 31s
Diagnosing CPU-related Issues 12m 24s
Introduction and CPU Utilization by Database 2m 4s
Demo: CPU Utilization by Database 35s
Top Worker Time Queries 1m 36s
Demo: Top Worker Time Queries 1m 31s
SP Worker Time 1m 44s
Demo: SP Worker Time 1m 16s
High Aggregate CPU Queries 1m 51s
Demo: High Aggregate CPU Queries 1m 11s
Module Summary 32s
Diagnosing Activity-related Issues 39m 53s
Introduction and Lock Waits 2m 35s
Demo: Lock Waits 59s
Scalar UDF Statistics 1m 40s
Demo: Scalar UDF Statistics 1m 9s
Input Buffer 1m 23s
Demo: Input Buffer 52s
Query Execution Counts 1m 52s
Demo: Query Execution Counts 1m 20s
SP Execution Counts 1m 58s
Demo: SP Execution Counts 1m 3s
SP Average Elapsed Time 2m 19s
Demo: SP Average Elapsed Time 1m 17s
Bad Nonclustered Indexes 1m 34s
Demo: Bad Nonclustered Indexes 1m 12s
Missing Indexes 2m 32s
Demo: Missing Indexes 2m 42s
Missing Index Warnings 1m 52s
Demo: Missing Index Warnings 53s
Overall Index Usage - Reads 1m 43s
Demo: Overall Index Usage - Reads 57s
Overall Index Usage - Writes 1m 30s
Demo: Overall Index Usage - Writes 50s
Volatile Indexes 1m 27s
Demo: Volatile Indexes 54s
Recent Resource Usage 1m 44s
Demo: Recent Resource Usage 52s
Module Summary 31s
Diagnosing Storage and Memory-related Issues 15m 59s
Introduction and Buffer Usage 2m 32s
Demo: Buffer Usage 51s
SP Logical Reads 1m 34s
Demo: SP Logical Reads 1m 6s
I/O Statistics by File 1m 25s
Demo: I/O Statistics by File 52s
SP Physical Reads 1m 35s
Demo: SP Physical Reads 47s
SP Logical Writes 1m 29s
Demo: SP Logical Writes 48s
Top I/O Statements 1m 23s
Demo: Top I/O Statements 36s
Module and Course Summaries 54s
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG4 Video (H264) 1280x720 30fps 281kbps [V: ETI ISO Video Media Handler (h264 high L3.1, yuv420p, 1280x720, 281 kb/s)]
Аудио: AAC 48000Hz stereo 96kbps [A: ETI ISO Audio Media Handler [eng] (aac lc, 48000 Hz, stereo, 96 kb/s)]
[spoiler="Скриншоты"]





[/spoiler]
Доп. информация: Level Intermediate
Duration 1h 30m
Released 5 Sep 2019