Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

i'm reading on Microsoft's site that SQL Server 2005 Express Edition has Profiler:

alt text

Profiler
Express
Local and Relational Servers only.

(i'm not sure what a non-relational SQL Server is, but whatever)

It says it's there, where is it?


In SQL Server 7, SQL Server 2000, SQL Server 2005 and SQL Server 2008, i would go to the Tools menu:

alt text

But in SQL Server 2005 Express Edition, Microsoft decided to hide it:

alt text

share|improve this question
add comment

3 Answers 3

Express only gives you the option of running server side traces for profiling, but I don't think it gives you free access to the SSMS tool?

Nonetheless, there is a perfectly good open source version of the profiler tool that should work with your express edition.

http://sites.google.com/site/sqlprofiler/

share|improve this answer
    
A third-party workaround is nice. i was actually hoping to understand Microsoft's documentation –  Ian Boyd Jul 7 '10 at 16:05
add comment

Remember that you're dealing with SQL Server Management Studio Express, which does not assume you have a copy of the rest of the SQL Server client tools installed.

Since this is SQL Server 2005, do a search for Profiler90.exe. That's the executable for Profiler. It is normally installed under C:\Program Files\Microsoft SQL Server\90\Tools\Binn.

share|improve this answer
    
C:\>dir profiler*.* /s --> File Not Found Damn, and it seems like such a plausible answer! –  Ian Boyd Jul 7 '10 at 16:03
    
Then it's not packaged with Express, only with the full client tools, unfortunately. SQLCMD and osql are packaged with SQL Express, probably because they are command line. Profiler obviously isn't. You can still use Profiler from a machine that has it installed, so long as you can connect to the database engine remotely. –  K. Brian Kelley Jul 7 '10 at 16:06
    
There is a way to do it command line. I wrote a blog article about it once: thegreenoak.blogspot.com/2009/04/… –  djangofan Mar 13 '12 at 0:29
add comment

To quote MSDN:

"Microsoft SQL Server Profiler is a graphical user interface to SQL Trace."

In other words, if you are willing to write a very small amount of code, you can run own your traces very easily.

share|improve this answer
    
Can you link that quote? –  Ian Boyd Jul 7 '10 at 16:06
    
Actually, it's a bit more than that... the quote is partially misleading. Server side traces tend to be less resource intensive because you're not fighting network traffic, etc. –  K. Brian Kelley Jul 7 '10 at 16:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.