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
Watch video The SECRET language of Azure SQL - Wait Stats! online without registration, duration hours minute second in high quality. This video was added by user Tales From The Field 08 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 266 once and liked it 15 people.