Truth, Art, and the Zen of SQL Server Performance Tuning

Total Running Time: 179 min

Some say performance tuning SQL Server is an art; others say it’s a science. It’s a bit of both of those, but also more. Many factors determine how well (or poor) SQL Server will perform, and it starts well before any application database is installed into an instance. Whether you’re a DBA/IT focused person or a developer, to properly provide your end users with the performance the business requires, you must ensure that not only do you pay attention to the application and things like queries and indexes, but also things like hardware, the OS, and basic configuration. The little things matter.

Over these three sessions, SQLHA’s Ben DeBow will take you on a journey through not only SQL Server-specific factors that you must take into account, whether deploying a brand new solution or troubleshooting an existing database or query, but also how hardware, the underlying operating system, architectures, and configurations all relate to SQL Server. The goal is to give you solid fundamentals that you can use every day. If you truly want a solid performance methodology for SQL Server and not just a one-off fix, sign up today.

Session 1: Where is My Performance Issue?

Session 2: Remove Your SQL Server Performance Barriers

Session 3: Index Tuning Foundations