Alex Rivera | Logout

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

Asked 2010-10-21T00:29:11.693
44

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?

sql-server t-sql profiling analysis
Edit
Report

3 Answers

44

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).

answered 2012-11-29T23:23:15.413
11

Default locations:

Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio for Query Analyzer. Programs > Microsoft SQL Server 2008 R2 > Performance Tools > SQL Server Profiler for profiler.

answered 2010-10-21T00:32:25.327
-2

Yes there is one and it is inside the SQLServer management studio. Unlike the previous versions I think. Follow these simple steps.

1)Right click on a database in the Object explorer 2)Selected New Query from the popup menu 3)Query Analyzer will be opened.

Enjoy work.

answered 2011-06-18T08:14:29.433

Your Answer