When it comes to SQL Server database performance, query tuning is critical. However, identifying the root cause of performance issues can be challenging, leading to frustration and time-consuming efforts. If you’re struggling with query tuning, this webcast is tailored for you.
In this session, Oracle ACE Director Janis Griffin will demonstrate how Foglight® for Databases by Quest® simplifies the process of finding and fixing problematic queries. You’ll learn to harness the powerful functionalities of tools like the multi-dimensional Performance Investigator and Quest SQL Optimizer to quickly rewrite queries or identify the best indexes. This systematic approach, regardless of your database's complexity or your skill level, will guide you to the correct tuning path, eliminating guesswork and saving countless hours on query tuning and SQL Server performance optimization.
Topics that will be discussed include:
- Using wait types to quickly identify bottlenecks and determine the best tuning approach
- Identifying inefficient operations through query execution plan reviews
- Rewriting queries to achieve optimal execution plans
Speaker
Janis Griffin
Oracle ACE Director, Quest Software