Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2144
  • Last Modified:

SQL Server Profiler - SQL Server 2008 R2

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
jfreeman2010
Asked:
jfreeman2010
  • 5
  • 4
1 Solution
 
ralmadaCommented:
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
 
jfreeman2010Author Commented:
I am not use SQL Express...
0
 
jfreeman2010Author Commented:
I should say I don't think I am using SQL express, how to find out?  thanks
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
ralmadaCommented:
run this in management studio

select @@version
0
 
jfreeman2010Author Commented:
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
 
ralmadaCommented:
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
 
ralmadaCommented:
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
 
vasureddymCommented:
i'm also facing similar problem.

i had sql server 2005 express
now i uninstalled sql server 2008 enterprise (Trail)
0
 
jfreeman2010Author Commented:
It works after I uninstalled all 2008 R2 release appls and reinstall them.

Thank you, Ralmada.!!!
0
 
jfreeman2010Author Commented:
thanks,
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now