Saturday, March 19, 2011

SQL Execution Plan Tuning

Two ways to find what's going wrong with your queries.

Execution plans! Don’t you just love them? They’re the first thing you look at when tuning a query or a stored procedure. But what do you do if you have a gigantic query play with 10’s of nodes? how do you find the most complex one? Where do you start?


http://weblogs.sqlteam.com/mladenp/archive/2010/01/21/SQL-Server-ndash-Find-the-most-expensive-operations-in-Execution.aspx


SQL Sentry
http://www.sqlsentry.com/plan-explorer/sql-server-query-view.asp

My hammer approach is to just save the query plan and then reopen in full screen.

No comments: