1 / 9

Identifying and Fixing Performance Problems Using Execution Plans

Grant Fritchey FM Global. Identifying and Fixing Performance Problems Using Execution Plans. Grant Fritchey. Principal DBA for FM Global Microsoft SQL Server MVP PASS Chapter President Author: SQL Server Execution Plans SQL Server 2008 Query Performance Tuning Distilled. Goals.

akina
Download Presentation

Identifying and Fixing Performance Problems Using Execution Plans

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Grant Fritchey FM Global Identifying and Fixing Performance Problems Using Execution Plans

  2. Grant Fritchey • Principal DBA for FM Global • Microsoft SQL Server MVP • PASS Chapter President • Author: • SQL Server Execution Plans • SQL Server 2008 Query Performance Tuning Distilled

  3. Goals • Learn how to read execution plans to identify common problems

  4. Agenda • Why Execution Plans • Where to Get Them • Playing With Execution Plans • Lookups • Missing Index • Bad Statistics • Recompiles • Ad Hoc SQL • Parameter Sniffing • Cursors • Multi-Statement Table Valued UDF • Query Hints • Sargeable • Questions

  5. Why Execution Plans? • The best window into Optimizer internals • Best way to figure out why queries behave as they do

  6. Where to get them? • SQL Server Management Studio • Sys.dm_exec_query_plan • Trace Events

  7. Playing with execution plans

  8. Goals • Learn several ways to access execution plans • Learn how to read execution plans to identify common problems

  9. Questions? • http://scarydba.wordpress.com/resources/

More Related