This 5-day class is focused on the many areas surrounding performance. While a class such the Immersion Event on Internals and Design should be taken prior to taking this class, this class also stands alone for anyone wanting to focus on some of the most important aspects of performance tuning for SQL Server.
There are many aspects to performance tuning – some should be done when the database is designed, prototyped and tested, while others must be implemented over time. Why can’t you do all of this during design? Data churn varies, user needs change and what the users told you during development often turns out to be untrue; the end result is that workloads change. The key to long term success is being able to understand, recognize and respond to these changes.
In terms of resource troubleshooting, we’ll introduce key concepts that explain how your SQL Server is performing – IO, SQLOS, waits, queues, and inconsistent plans – and explain how to investigate performance issues related to them. We’ll focus on features that allow better analysis and/or control to constrained and protect critical workloads and perform very in-depth troubleshooting.
SQL Server versions covered:
Please note: demos will vary between versions and questions can be answered on any releases from SQL Server 2000 through the current release. And, if you’re a glutton for punishment and have even older versions, feel free to ask questions about any version ever released – someone on the team can probably answer it!
For a detailed agenda click HERE.
If you need help justifying training to your organization, we can help you:
If you have any questions, please contact us.