The SECRET language of Azure SQL - Wait Stats!
@SQLBalls from @Tales-from-the-Field talks about the SECRET language you need to understand to know the bottlenecks your SQL Server, @AzureSQL Database, or @azuresqlmanagedinstance faces.
This really isn't a secret, it's hiding in plain sight. @Microsoft wants you to know about it. The SQL PG wants you to know about it! WE want you to know about it!
First Stop:
Paul Randal - The OG Wait Stats Blog
SQL Server Wait Statistics (or please tell me where it hurts…)
https://www.sqlskills.com/blogs/paul/...
Paul's script is a godsend!
Thomas LaRock's Book
https://thomaslarock.com/2022/10/pro-...
#SQLBalls GitHub - Script Used in this video
https://github.com/sqlballs/SQLScript...
#Microsoft Doc's Wait Stats Objects
https://learn.microsoft.com/en-us/sql...
#Microsoft Doc's sys.dm_os_wait_stats
https://learn.microsoft.com/en-us/sql...
Chapters:
00:00 What are we covering today?
00:10 Crank up the Music & ENJOY! Don't Skip it!
00:20 Let me tell you a little story about Tales from the Field
00:38 Conceptual overview of Wait Stats. This the simple way you explain them to look really smart
03:42 Credit where credit is due Paul Randal the OG
04:22 Demo on Azure SQL Database - SOS_SCHEDULER_YEILD
08:53 Demo on Azure SQL Database - WRITELOG
10:46 Demo on Azure SQL Managed Instance - WRITELOG
12:48 GitHub Repo & Getting the Demo Script
13:10 CRITICAL CONCEPT TO UNDERSTAND
Смотрите видео The SECRET language of Azure SQL - Wait Stats! онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Tales From The Field 08 Март 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 266 раз и оно понравилось 15 людям.