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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment