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

Содержание

Course Overview 1m 25s Course Overview 1m 25sIntroduction 5m 26s Introduction and DMV Queries 1m 39s Diagnosing Issues and Benefits of DMV Queries 1m 59s Course Details and Module Summary 1m 47sDiagnosing 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 31sDiagnosing 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 32sDiagnosing 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 31sDiagnosing 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

Скриншоты