tsql - Where is the Query Analyzer in SQL Server Management Studio 2008 R2?

Question

I have some SQL thats getting run and it is taking to long to return the results / parse / display, etc. in a asp.net c# application.

I have SQL Server Management Studio 2008 R2 installed to connect to a remote SQL Server 2000 machine. Is there a Query Analyzer or profiler I can use to see whats going on? I'm not sure if I'm sending too many requests, if the requests are taking too long, if there are additional indexes I can add to speed things up etc.

EDIT:

Any free tools out there that are replacements for the Microsoft tools?

Answer 1

To analyze a query you already have entered into the Query editor, you need to choose "Include Actual Execution Plan" (7th toggle button to the right of the "! Execute" button). After executing the query, you need to click on the "Execution Plan" tab in the results pane at the bottom (above the results of the query).