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.