A Beginner's Guide to Becoming a Performance Tuner
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.