Author: sqlmechanic
-
Presentation deck – WUG SQL Server Bootcamp 2026
Query Store and the DMVs tell you what is slow on average — and the tickets on your desk are never average. This 75-minute session takes three real tickets and closes each one with evidence pulled straight off the server: the actual plan of one bad execution, the parameters that were really passed in, the…
-
Case Study: Unlocking Massive I/O Throughput in Azure SQL Managed Instance Using File-Level Parallelism
Client Challenge: A client operating on Azure SQL Managed Instance – General Purpose tier was experiencing significant performance limitations. Their workload required higher IOPS and throughput, but the General Purpose tier relies on standard Azure managed disks, which scale performance solely based on disk size. The result? To get more IOPS and throughput, the client had to provision one…