Solved

SQL Server Profiler - SQL Server 2008 R2

Posted on 2010-11-18
10
2,111 Views
Last Modified: 2012-05-10
I installed SQL Server 2008 R2 on my pc and can't find the SQL Server Profiler

After installed, I have the following installed in my pc:

configuration tools
integration services
import & export data (32-bit)
SQL Server Management Studio
SQL Server Business Intelligence Development Studio

This is the option I selected:

set up processing -> installation -> new installation or add features to an existing installation ->
sql server feature Installation -> shared features ->
In the shared features the following were checked:
business Intelligence Development studio
Client Tools connectivity
Integration Services
Client Tools Backwards compatibility
Client Tools SDK
Management Tools - Basic
SQL Client Connectivity SDK

What I am looking for is Performance Tools -> SQL Server Profiler
0
Comment
Question by:jfreeman2010
  • 5
  • 4
10 Comments
 
LVL 41

Expert Comment

by:ralmada
Comment Utility
Are you trying to install SQL Express? SQLEXpress does not have Profiler
http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

You have some alternatives though, like this one
http://sites.google.com/site/sqlprofiler/
0
 

Author Comment

by:jfreeman2010
Comment Utility
I am not use SQL Express...
0
 

Author Comment

by:jfreeman2010
Comment Utility
I should say I don't think I am using SQL express, how to find out?  thanks
0
 
LVL 41

Expert Comment

by:ralmada
Comment Utility
run this in management studio

select @@version
0
 

Author Comment

by:jfreeman2010
Comment Utility
Standard Edition

icrosoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 41

Expert Comment

by:ralmada
Comment Utility
could it be that you had SQL 2008 express installed before? If so you might want to try uninstalling your current standard edition and try installing again. Check this link:

http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/4808224c-1adb-4e43-8ae8-c45aba48abb1
0
 
LVL 41

Accepted Solution

by:
ralmada earned 500 total points
Comment Utility
Hold on, Also when you install, check Management Tools - Basic and make sure that
"Management Tools - Complete" is checked. If you don't have that option there, then probably is because you had a previous Express version that was causing trouble. So you will have to go with my previous comment.

http://blogs.msdn.com/b/psssql/archive/2008/09/02/sql-server-2008-management-tools-basic-vs-complete-explained.aspx
0
 
LVL 2

Expert Comment

by:vasureddym
Comment Utility
i'm also facing similar problem.

i had sql server 2005 express
now i uninstalled sql server 2008 enterprise (Trail)
0
 

Author Comment

by:jfreeman2010
Comment Utility
It works after I uninstalled all 2008 R2 release appls and reinstall them.

Thank you, Ralmada.!!!
0
 

Author Closing Comment

by:jfreeman2010
Comment Utility
thanks,
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now