Product has been added to your cart.

1.5 The Tuning Robots in SQL Server 2017, 2019, and 2022

Each new version of SQL Server has brought a few new automated performance tools: adaptive joins, adaptive memory grants, interleaved execution for MSTVFs, and “automatic tuning” (which is a laughable name given what the feature actually does.) We’ll talk through what each feature does and what it requires, and you’ll see why it didn’t fix…

To access this incredible, amazing content, you gotta get Mastering Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.

Each new version of SQL Server has brought a few new automated performance tools: adaptive joins, adaptive memory grants, interleaved execution for MSTVFs, and “automatic tuning” (which is a laughable name given what the feature actually does.) We’ll talk through what each feature does and what it requires, and you’ll see why it didn’t fix…

To access this incredible, amazing content, you gotta get Mastering Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.