Where is SQL Profiler in my SQL Server 2008?

Question

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?

Mitch Wheat · Accepted Answer · 2010-11-24T00:02:33.937

47

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

edited Nov 24 '10 at 00:02

answered Mar 11 '09 at 03:23

Mitch Wheat

295,962
43
465
541

I was looking this. its cool that it is free. :) How can I save trace data to text file? File/Save button is disabled – Zviadi Feb 10 '12 at 12:55
DataWizard is now only free as time-limited trial, but licences start at just $5 USD for a year for up to 3 servers.Don't be put off by the problems with the DataWizard website (it often takes you round in circles) - the software itself is excellent and I'm assured by Joe at DataWizard.com they are working on improving the website... (fingers crossed!) – Chris Aug 08 '12 at 07:02
3

It is no longer available from that download link. – fasih.rana Jun 14 '16 at 08:45

score 24 · Answer 2 · edited Jul 08 '14 at 16:09

24

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

edited Jul 08 '14 at 16:09

EricP

3,395
3
33
46

answered Aug 30 '13 at 20:50

Eslam Badawy

533
6
8

score 8 · Answer 3 · answered Jan 07 '13 at 00:37

8

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

answered Jan 07 '13 at 00:37

jonmiddleton

1,122
14
16

score 3 · Answer 4 · edited Mar 28 '13 at 13:37

3

Management Studio->Tools->SQL Server Profiler.

If it is not installed see this link

edited Mar 28 '13 at 13:37

John

29,788
18
89
130

answered Jun 11 '10 at 13:24

kerem

55
1

9

In what SKU? I have 2008 R2 management studio installed and don't have a profiler. – James Dunne Dec 20 '11 at 18:59

score 0 · Answer 5 · answered Mar 24 '09 at 08:09

0

Also ensure that "client tools" are selected in the install options. However if SQL Managment Studio 2008 exists then it is likely that you installed the express edition.

answered Mar 24 '09 at 08:09

Eddie Groves

33,851
14
47
48

Where is SQL Profiler in my SQL Server 2008?

5 Answers5