Whether you're a developer, IT manager or an accidental DBA, at some point, you'll run into query performance problems. Beyond adding an index, you may not know how to make it work better. Microsoft SQL Server MVP Andy Warren and Oracle ACE Director Janis Griffin are here to help. In this session, you’ll learn tricks and tips to quickly improve query performance.
We'll go over a simple list of triage steps that will help you understand the problem. Then, we’ll see which of our solution patterns is most likely to work. For example, when we say query performance is slow, it's useful to understand if it's always slow, only slow at certain times or only slow for certain customers.
We'll also show you how to:
- Ensure query performance easily
- Know if blocking was involved
- Identify missing indexes
- Understand why plans sometimes "go bad"
- Fix some queries and improve SQL Server performance
You’ll learn how patience and thinking of query tuning in the same way that you think of debugging any problem, will help you solve your query performance issues.
Intervenants
- Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former president of the Orlando SQL Server Users Group and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.
- Janis Griffin has more than 30 years of DBA/database experience, including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business-to-business applications. Janis also held positions as a principal architect and senior manager, mentoring other DBAs on best practices in database performance tuning.