Join me Friday, January 29, 2016 for a full day of performance tuning training as part of SQLSaturday 461 in Austin, TX. Then stick around for the main event on Saturday where I will be among the many great presenters at the SQLSaturday event. My regular session on Saturday in the last slot of the day will be Strategies for Working with Texas-sized Databases.
Learn more about the event: SQLSaturday 461
Register for the pre-con: Performance Tuning Like a Boss Pre-conference Session
My regular session on Saturday: Strategies for Working with Texas-sized Databases
Pre-con: Performance Tuning Like a Boss
Performance tuning uses troubleshooting techniques that you can adopt for your own. It’s not just trial-and-error, and it’s definitely not magic unicorn dust. You will learn to recognize the difference between symptom and root cause to address the real underlying issue. Dive deeper into some of the common problems that are the most difficult to prevent, diagnose, and correct.
Some of the troubleshooting methods covered will include waits and queues, performance monitoring, baselining, and benchmarking. Equally as important as learning what to do, you will also learn how to avoid common pitfalls — or what not to do.
We will also take an in-depth look at the new performance tuning tools coming in SQL Server 2016: Query Store, Live Query Statistics, and Query Plan Comparisons. These tools are going to change how SQL professionals identify and tune problem queries. They are the biggest change to performance tuning since Dynamic Management Views were introduced in SQL Server 2005.
Full list of topics:
- Configuring SQL Server for Optimal Performance
- Memory, parallelism, tempdb
- Diagnosing Poor Performance with Wait Statistics
- Tuning Queries with Execution Plans
- Indexing for Performance
- Identifying and Remediating Plan Regression With Query Store and Query Plan Comparison
- Using Live Query Statistics to identify Bottlenecks in Query Plans
- Learn how to identify and fix the root cause of performance problems rather than just reacting to the symptoms
- Understand how to proactively prevent common performance problems by configuring SQL Server to perform optimally
- Discover how the new performance tuning features of SQL Server 2016 can take your performance tuning skills to whole new levels of greatness
- Gain the confidence to know you can take on any performance problem and come out looking like the hero.
- Basic familiarity with Dynamic Management Views (DMVs) and query plans
- A desire to be the person everyone looks for when there is a performance issue
Regular session: Strategies for Working with Texas-sized Databases
Very large databases (VLDBs), or just “databases” as they’re known in Texas, are just like regular databases, right? There’s just more of them to love.
Working with very large databases can be difficult and tricky at times. Everything takes longer, there’s more locking, more logging, and minor issues become major very quickly. In this session you will learn some strategies for working with VLDBs such as how to speed up backups and restores, how to fit index maintenance and integrity checks into a thin maintenance window, and how to efficiently and quickly set up failover partners and replicas.