Understanding SQL Server Query Execution Plans

Unsupported OS

Understanding query execution plans is something many IT professionals either don’t know about or don’t fully understand. SQL Server’s programming language, T-SQL, is different from most other programming languages. In most languages, you tell the language what you want it to do, but in T-SQL, you tell it what you want. This means you are at the mercy of the query optimizer, which will take the logical instruction and convert it into a physical plan. The query execution plan is a map of what the optimiser thinks will be a good way of returning the data you have asked for. Being able to understand query plans and what they show is critical for both DBAs and developers in uncovering query performance problems.

In this session, Richard Douglas will explain:
- Where to find a query plan
- How to read a query plan
- How to find common performance problems without looking at the code
- Where the query optimiser and other features of SQL Server can cause sub-optimal plans.


About the presenter:
Richard Douglas is a Systems Consultant for a vendor of SQL Server solutions where he specialises in SQL Server providing solutions and system health checks to organisations across the EMEA region. Richard has recently taken on the responsibility of being Editor in Chief of the community site Toad World which provides articles on SQL Server and a blog syndication service, other duties see him regularly presenting webinars to both US and EMEA audiences. He is also a keen member of the SQL Server community, he founded and runs a PASS affiliated chapter in the UK (www.SQLStudy.org) and is on the organising committee for a national event called SQLRelay.

-----------------------------
Sponsored by:
Dell Software
http://software.dell.com/
This recorded Webinar is only available for Windows 2000 or higher.