Discover essential performance tuning techniques for SQL Server in this comprehensive conference talk from PASS Data Community Summit. Explore common worst practices that hinder SQL Server performance, covering both administrative and T-SQL development aspects. Gain insights into server configuration mistakes, T-SQL parallelism, and TempDB challenges through numerous demonstrations. Learn valuable tools and knowledge to kickstart your journey as a performance tuning specialist, whether you're a DBA or developer. Delve into topics such as power management, default settings, AutoGrowth, Cost Threshold for Parallelism, query optimization, procedural vs. declarative programming, key lookups, indexing strategies, and TempDB spills. Equip yourself with practical skills to identify and resolve hidden performance killers in SQL Server environments.
Overview
Syllabus
Intro
PASS Summit 2020 Goes Virtual Be there. Wherever you are.
Andy Yun
Wide World Out There
Today's Agenda Administrative Practices
All The Power
High Performance - Always!
Power to the Shell Learn More
Change Those Defaults
Change Me
Model After Me
AutoGrowth Recap Learn More
How Does It Work?
#3 - Cost Threshold for Parallelism Recap
Large Queries
Languages Matter
Follow The Recipe
Procedural: Follow The Directions
Declarative: Doing It My Way
#4 - Large Query Recap Learn More
Key Lookups (& Indexes)
Look It Up
Key Lookups Recap
TempDB Spills
Taught by
PASS Data Community Summit
