Quest Database Training Days, September 2-30, 2021

Your users are complaining that SQL Server is slow, but you can't fix the code or the database, and the company isn't throwing hardware at the problem yet. What can you do? Use specific configuration changes to reduce the hardware required to run queries.We'll discuss blocking and other scenarios where SQL Server's configuration switches make all the difference. Code and indexes may still need work, but you'll have a few options to help in the meantime.

SQL Server 2019 has been available for a while, but we’ve noticed many people don’t use it to its full potential. In this fast-paced, demo-oriented session, we’ll go over the new features that maximize SQL Server performance. We’ll also discuss what to do if you’ve recently upgraded SQL Server and your performance is missing the mark.

The SQL Server Query Optimizer creates an execution plan for every statement running in the database. But sometimes it chooses a bad query plan, slowing the query and eating resources, so other processing can’t get done. Learn how to read and fine-tune query plans for better performance. We’ll go over the types of execution plans and when to use them. We’ll also examine the different operators, their statistics and costs; then determine steps to focus on tuning. As an added bonus, you’ll also learn several troubleshooting techniques. 

See the tools and capabilities that’ll make you an even more effective database developer. We’ll cover database projects, unit testing and Continuous Integration and Continuous Deployment. You’ll learn about data collaboration tools from erwin^® by Quest^® and coding tools like Github Copilot (AI code writing). You’ll find at least one solution that’ll help you get more done with your time.

Learn how to use native tools in SQL Server and scripts based on Dynamic Management Views (DMVs) to swiftly identify and resolve performance bottlenecks. In this session, you’ll discover effective methods for diagnosing performance issues and gain actionable insights that you can apply immediately to optimize your SQL Server environment.

Topics that will be discussed include:

• Utilizing SQL Server native tools for performance monitoring
• Leveraging Dynamic Management Views (DMVs) to pinpoint bottlenecks
• Practical scripts to diagnose and resolve performance issues
• Strategies for optimizing SQL Server performance

Speaker:

• Pinal Dave, SQL Server Performance Tuning Expert at SQLAuthority.com