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

views:

answers:

+2 Q:

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

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?

+3 A:

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.

bobs 2010-10-21 00:32:25

Neither of these options exist for me. I'm guessing they weren't installed then.

Justin808 2010-10-21 00:35:16

Could be. Default install mode may not install client tools. You many need to install client tools.

bobs 2010-10-21 00:37:11

+1 A:

From in Sql Server Management Studio: Tools -> Sql Server profiler. Although as @bobs said, you may need to install additional components first.

cofiem 2010-10-21 00:49:59

+1 A:

I know the question doesn't state SQL Server express, but its worth pointing out that the SQL Server Express editions don't come with the profiler (very annoying), and I suspect that they also don't come with the query analyzer.

Kragen 2010-10-21 00:50:48

yah, the analyzer isn't part of the install :-/ way to go MS.

Justin808 2010-10-21 01:21:32

ansaurus

tags:

views:

answers:

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

related questions