Query Analyzer in SQL 2k5
-
Hi everyone,
As I learned, the Query Analyzer from SQL 2000 was transformed into something different in SQL 2k5, which is now Query Editor.I just would like to know if is here any discussion,site, where I could learn more on how to use similar techniques to analyze the query plan.There are Display Estimated Query Plan and Analyze Query in Database Engine Tuning Advisor if you right click the query you want to analyze, but not sure if that is the equivalent to Q.
My question is simply:
How can I analyze the query plan in SQL 2k5 and where to find appropriate information on it?
Cheers
Ben
-
just look at the Toolbar buttons in SSMS when you open a "new query" window.
* Noel -
Noel,
what the button is called, because there are couple of buttons similar but not the same as in SQL 2000,like:
Display Estimated Execution Plan
Analyze Query in Database Engine Tuning Advisor
Design Query in Editor
Include Actual Execution Plan
?
What I am looking for is a service(QA) where I can analyze the execution plan for my particular script, which is already written.
I am using SQL 2005
Ben
-
Just Besides the "Cancel Executing Query" (stop sign) you can find "Display Estimated Execution Plan"
Hope you can find it
* Noel -
Yep I see
Just I did read it is not the same as the QA, as it is only an estimation and there is a difference when the query is executed and analyzed using graphics.
But you are right, it is next to the Stop button
Ben
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply