The Performance Virtual Group's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Login to Subscribe

Welcome to the Performance Virtual Group

Next Meeting

Performance Tuning – Analyzing Query Execution

Thu, Jun 26 2014 18:00 UTC

Performance Tuning – Analyzing Query Execution

Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations. <BR> <BR>In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation. <BR> <BR>Goals: <BR>1. Understand all common base table operations and how they can affect performance of the overall SQL queries. <BR>2. Identify the most expensive operations of an execution plan and how to begin to formulate an action plan in which to improve performance. <BR>3. Comprehension of the relationship of join types and their base table operations and how the relationships can affect overall instance performance.

Konstantin Melamud

Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQL Saturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.

Webinar Links

Contact the Performance Virtual Group

Are you interested in being a Presenter, getting involved with the Group or simply provide us with some feedback? Please fill in the form below

Your Contact Information

Your Feedback

Thank you for contacting us, we will get back to you as soon as possible!
Back to Top