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

Welcome to the Performance Virtual Chapter

The Performance Virtual Chapter events are held on the 4th Thursday of each month at 2PM ET.  Every month there is a drawing for a $100 Amazon gift card sponsored by Confio.  To be eligible, you just need to attend our monthly webcast.  A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address. 



You can follow us on Twitter @SQLPASS_PVC

Join our Google Group Distribution List for the latest updates and meeting announcements.

Congratulations to the October Gift Card Winner...Brian Sload!

 

GoToWebinar requires registration through the RSVP link below.
Next Meeting

Thu, Jun 26 2014 14:00 Eastern Daylight Time


Performance Tuning – Analyzing Query Execution

RSVP: None

Recording: https://attendee.gotowebinar.com/recording/5564696877271991041

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.

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.

Goals:
1. Understand all common base table operations and how they can affect performance of the overall SQL queries.
2. Identify the most expensive operations of an execution plan and how to begin to formulate an action plan in which to improve performance.
3. Comprehension of the relationship of join types and their base table operations and how the relationships can affect overall instance performance.


Konstantin Melamud is a Manager of SQL Server Performance and Tuning at RDX. He works with over 400 customers on solutions within the SQL Server environment and leads code tuning team within Remote DBA experts. He is passionate about educating users on SQL Server by speaking at user groups, conferences, and labs.

Event Attachments