SQL Server Performance Forum – Threads Archive
Management Studio Execution Plan and Tuning
I am trying to get used to Management Studio and my biggest frustration is in the execution plan. In query analyzer you could right click a table in the execution plan and update statistics or create an index. Where did this go? It’s a pain to scroll through tables in the object explorer. AM I missing a button or menu option? Thanx, ThanxAdam
See this BOL text helps:
quote:
Open or type a Transact-SQL script that contains the queries you want to analyze into the Management Studio query editor. After the script has been loaded into the Management Studio query editor, you can choose to either display an estimated execution plan or the actual execution plan by clicking the Display Estimated Execution Plan or the Include Actual Execution Plan button on the query editor toolbar. If you click Display Estimated Execution Plan, the script is parsed and an estimated execution plan is generated. If you click Include Actual Execution Plan, you must execute the script before the execution plan is generated. After the script is parsed or executed, click the Execution Plan tab to see a graphical representation of execution plan output.
Open or type a Transact-SQL script that contains the queries you want to analyze into the Management Studio query editor. After the script has been loaded into the Management Studio query editor, you can choose to either display an estimated execution plan or the actual execution plan by clicking the Display Estimated Execution Plan or the Include Actual Execution Plan button on the query editor toolbar. If you click Display Estimated Execution Plan, the script is parsed and an estimated execution plan is generated. If you click Include Actual Execution Plan, you must execute the script before the execution plan is generated. After the script is parsed or executed, click the Execution Plan tab to see a graphical representation of execution plan output.
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
K, I do that but I can’t right click the graphical objects in the execution plan anymore to create indexes or update statistics on that object (table) like I could in query analyzer. Thanx
Adam
that feature is gone from showplan in SSMS. [<img src=’/community/emoticons/emotion-6.gif’ alt=’
‘ />]<br /><br /><hr noshade size="1">SqlSpec – a fast, cheap, and comprehensive data dictionary generator <br />for SQL Server 2000 and 2005 and Analysis Server 2005 – www.elsasoft.org <br />
True and you need to adopt new measure in SSMS with SQL 2005. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Bummer, I really liked that feature. Thanx
Adam
]]>