Performance VC Meeting Thursday 6/26/2014 @ 2PM ET
Jeff Renz
Session
Performance Tuning – Analyzing Query Execution
Abstract
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.
Bio
Konstantin Melamud is a Manager of SQL Server Performance and Tuning for Remote DBA Experts. 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..
Meeting Details:
June 26th, 2014, 2PM
ET
GoTo Webinar: https://attendee.gotowebinar.com/register/1254440871617041921
Ryan Adams
Hi folks.
We also wanted to make sure everyone was aware that the price for the PASS Summit in Seattle this year goes up by $300 after Friday June 27th. Right now the full conference rate is $1595, but after 6/27 it jumps to $1895.
You can use our chapter code to save $150. The code can be used at any time, but if you use it before Friday June 27th you’ll only pay $1445!
Here is the code:
VCSUM23
Ryan J. Adams
PASS Performance Virtual Chapter President
NTSSUG Director of Programs/Finance
PASS Regional Mentor – U.S. South Central
MCP MCSA MCSE MCDBA MCTS MCITP
--
You received this message because you are subscribed to the Google Groups "PASS Performance Virtual Chapter" group.
To unsubscribe from this group and stop receiving emails from it, send an email to perfvc+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.