Managing SQL Server Database Performance Год выпуска: 2021 Производитель: Pluralsight Сайт производителя: https://www.Pluralsight.com Автор: Viktor Suha Продолжительность: 3h 11m Тип раздаваемого материала: Видеоклипы Язык: Английский Субтитры: Английские Описание: SQL Server performance problems are real and troubleshooting can be a challenge. This course will cover what factors affect performance and how to troubleshoot and optimize performance both on-premise and with Azure SQL Database. Проблемы с производительностью SQL Server реальны, и устранение неполадок может стать проблемой. В этом курсе будут рассмотрены факторы, влияющие на производительность, а также способы устранения неполадок и оптимизации производительности как локально, так и с помощью базы данных SQL Azure. This course is part of: Developing SQL Server Databases Path
Содержание
Course Overview 1m 43s Course Overview 1m 43s Aiming for Performance and Scalability 13m 58s Introduction 2m 40s A Holistic and Layered Approach 2m 10s Definitions and Methods 2m 4s Aiming for Scalability and Performance 3m 30s Scope and Assets 2m 19s Overview 1m 12s Understanding Key SQL Server Concepts 39m 31s Major Versions and Compatibility Levels 4m 51s Patch Levels and Servicing 3m 24s Editions and Best Practices 2m 9s Server Instances 2m 22s Server Configuration Options 1m 36s Database Configuration Options 2m 22s Trace Flags 3m 9s Tempdb 2m 48s Transaction Log and Recovery Models 3m 43s Memory Management and SQLOS 5m 24s Wait Statistics and the Threading Model 7m 38s Optimizing SQL Server Instance and Memory Configuration 16m 47s Server Health Check 3m 41s Demo: Memory Settings 6m 21s Demo: Parallelism Settings 2m 44s Demo: ERRORLOG Files 4m 1s Optimizing Tempdb and User Database File Configuration 14m 46s Database File IO 6m 5s Instant File Initialization and Tempdb Bottlenecks 4m 7s Demo: Autogrowth Settings 2m 9s Demo: Tempdb Configuration 2m 24s Configuring SQL Server in Azure 34m 34s SQL Server in Azure 4m 35s SQL Server Virtual Machines 4m 13s Demo: Creating SQL Server Virtual Machines and Sizing 8m 31s Azure SQL Database 6m 20s Elastic Pools 4m 47s Demo: Estimating Service Tiers and Sizes 6m 6s Troubleshooting and Baselining the Environment 48m 12s Troubleshooting and Baselining in SQL Server 4m 21s Wait Statistics in Practice 5m 29s IO and CPU Related Wait Type Patterns 4m 39s OS, Locking, and Data Page Related Wait Type Patterns 2m 29s Wait Statistics Patterns in Troubleshooting 4m 52s Demo: Wait Statistics Analysis with Custom Query 2m 44s IO Performance Troubleshooting with DMVs 2m 13s Demo: IO Performance Analysis with Custom Query 1m 23s Query Store 2m 2s Demo: Using the Query Store for Query Performance Analysis 3m 13s System_health Session Trace 1m 53s Demo: Using the System_health Session Trace for Troubleshooting 1m 47s Perfmon Traces 3m 51s Interesting SQL Server Counters 1m 38s Page Life Expectancy Patterns 2m 0s Demo: Using and Analyzing Perfmon Traces 2m 28s Module Summary 1m 3s SQL Server 2019 Improvements 21m 40s Database and Server Upgrade 1m 19s Versions, Editions, and Patching 3m 17s Setup 2m 6s Tempdb 2m 44s Query Store 1m 14s Accelerated Database Recovery 1m 51s Sequential Key Insert Optimization 1m 17s Intelligent Query Processing 3m 27s References 1m 8s Module and Course Summary 3m 13s
Файлы примеров: присутствуют Формат видео: MP4 Аудио: AAC 48000Hz stereo 96kbps Видео: MPEG4 Video (H264) 1280x720 30fps 180kbps
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
