Database Training Days 101: Troubleshooting Poor SQL Server Query Performance with MSSQLTips

Whether you're a developer, IT manager, or an accidental DBA, at some point, you'll encounter query performance problems. Beyond adding an index, you may not know how to make it work better. In this session, Microsoft SQL Server MVP Andy Warren and Oracle ACE Director Janis Griffin are here to help. Learn valuable tricks and tips to quickly improve query performance. We’ll walk you through a simple list of triage steps to help you understand the problem, then explore solution patterns that are most likely to work based on the specific performance issues you're facing. Whether the query performance is always slow, slow at certain times, or slow for certain customers, you'll gain the tools you need to diagnose and resolve these challenges.

Topics that will be discussed include:

• Ensuring query performance with simple, actionable steps
• Understanding if blocking was involved in performance issues
• Identifying and addressing missing indexes
• Recognizing why query plans sometimes "go bad"
• Practical strategies for fixing queries and improving SQL Server performance

Speakers:

• Andy Warren, SQL Server Consultant and Microsoft SQL Server MVP
• Janis Griffin, Oracle ACE Director at Quest Software