Missing the Old 2005 Query Analyzer

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Missing the Old 2005 Query Analyzer

Author

Topic

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-02-14 : 16:34:59

I'm sure others loved the graphical chart that we could get in 2005
You could run a query statement to get a view of each step in a diagram showing the % of resources each step used.

I thought I could get the same in 2008 R2 by
executing
Set showplan_XML ON;
followed by my query but all it gives is a boatload of text.

Have I overlooked something, is there any way to get the graphical diagram in 2008?
Thanks, Jack

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-02-14 : 16:37:13

Click on the Query menu and then either "Display Estimated Execution Plan" or "Include Actual Execution Plan", depending on which you want.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

robvolk
Most Valuable Yak

15732 Posts

Posted - 2014-02-14 : 16:50:06

I'll recommend Plan Explorer:

http://sqlsentry.net/plan-explorer/sql-server-query-view.asp

The free version is very nice, although it doesn't graph to my knowledge. The Pro version does more. Either way you won't care about using the plan viewer in SSMS anymore.

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-02-14 : 17:54:15

quote:
Originally posted by tkizer

Click on the Query menu and then either "Display Estimated Execution Plan" or "Include Actual Execution Plan", depending on which you want.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Thanks Tara. That's exactly what I was looking for.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources