Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Where is SQL Profiler in my SQL Server 2008?

Tags:

sql-server

profiling

sql-server-profiler

I downloaded SQL Server 2008 and can't seem to find SQL Profiler anywhere.

I believe I installed the SQL Server Enterprise Express/trial version?

I guess it was Express and not Enterprise after all right?

like image 660
mrblah Avatar asked Mar 11 '09 03:03

mrblah

People also ask

How do I find SQL Server SQL Profiler?

Click Start, point to Programs, click Microsoft SQL Server 20xx (your version), click Performance Tools, and then click SQL Server Profiler.

What replaced SQL Profiler?

A new hope: The Extended Events (XE) XE will replace the SQL Profiler in the future versions. By the moment, SQL Server includes Profiler and XE. The XEs is a feature included in SQL Server 2008. It is a lighter option that consumes less resources than the Profiler.

What is SQL Profiler in SQL Server?

SQL profiler is a GUI tool in Microsoft SQL Server relational database management system that allows us to monitor, analyze, troubleshoot, re-create, and trace the problems of SQL databases and their environments. It was first introduced in the SQL Server 2000 version.

4 Answers

first get the profiler Exe from: http://expressprofiler.codeplex.com

then you can add it simply to the Management studio:

Tools -> External tools... ->

a- locate the exe file on your disk (If installed, it's typically C:\Program Files (x86)\ExpressProfiler\ExpressProfiler.exe)

b- give it a name e.g. Express Profiler

that's it :) you have your Profiler with your sql express edition

enter image description here

like image 44
Eslam Badawy Avatar answered Oct 17 '22 12:10

Eslam Badawy

SQL Server Express does not come with profiler, but you can use SQL Server 2005/2008 Express Profiler instead.

like image 97
Mitch Wheat Avatar answered Oct 17 '22 12:10

Mitch Wheat

Another very basic free profiler: http://expressprofiler.codeplex.com

like image 8
jonmiddleton Avatar answered Oct 17 '22 13:10

jonmiddleton

Management Studio->Tools->SQL Server Profiler.

If it is not installed see this link

like image 3
kerem Avatar answered Oct 17 '22 11:10

kerem
Sign in to Comment

Related questions

@@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
Management Studio default file save location
SQL Server Agent Job - Exists then Drop?
Downsides to "WITH SCHEMABINDING" in SQL Server?
How can I compare time in SQL Server?
How do I swap column values in sql server 2008?
What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
What is the connection string for localdb for version 11
What are Covering Indexes and Covered Queries in SQL Server?
The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'
How do I return multiple result sets with SqlCommand?
How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
The parameterized query expects the parameter which was not supplied
Why is it considered bad practice to use cursors in SQL Server?
How to export SQL Server 2005 query to CSV
Node.js MSSQL tedius ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED
Convert Time DataType into AM PM Format:
How can I tell if a database table is being accessed anymore? Want something like a "SELECT trigger"
INNER JOIN vs INNER JOIN (SELECT . FROM)
What accounts to use when installing SQL Server 2008 Developer

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!