Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where is SQL Profiler in my SQL Server 2008?

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