SQL Server with Mr. Denny:

Execution Plan

1

March 12, 2009  11:00 AM

Back To Basics: Reading an Execution Plan



Posted by: Denny Cherry
Back To Basics, Execution Plan, Index Performance, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008

All to often when helping people look at query performance problems I'll ask them to look at the execution plan, and see what it says.  Most query performance problems can be resolved simply by looking at the execution plan and seeing where you need to add an index. All to often I (and others)...

May 1, 2008  9:00 AM

Checking the cached execution plans



Posted by: Denny Cherry
Cache, Execution Plan, Query tuning, SQL Server 2005, sys.dm_exec_cached_plans, sys.dm_exec_plan_attributes, sys.dm_exec_query_plan, sys.dm_exec_requests

As we all know SQL Server, will for good or bad, cache execution plans.  Up until now it's been very tough to see the cached execution plans.  You pretty much had to grab the query or procedure (with the parameters) and run it with Query Analyzer and have it return the execution plan.  The only...


October 29, 2007  8:00 AM

Easy way to read XML execution plans.



Posted by: Denny Cherry
Execution Plan, SQL

Take your XML execution plan and save it to a file with a file extension of sqlplan (such as MyQuery.sqlplan) and double click on it.  It will open in the SQL Server Management Studio and show you the plan in the GUI plan viewer making it much easier to read than the XML version.


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: