Q

View query execution plan in SQL Server with this method

Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree cost.

Can you brief me on how to check and understand a query execution plan in SQL Server?
From my perspective, the best approach to review a SQL Server query plan is via the graphical approach with either Management Studio or Query Analyzer. Just review the tool bar on each application to find the correct icon. After you run the query, you will see the graphical query plan in the results section of the window as a separate tab. From that point forward, hover your mouse over the icon on the far left of the window to obtain the overall sub tree cost. Then review the other icons with high percentages of the query plan to determine the potential issues. As you make changes to the query, continue to review the query plan and validate the overall sub tree cost is decreasing.
This was first published in December 2007

Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

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

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close