Where is SQL Profiler in my SQL Server 2008?
SQL Server Express does not come with profiler, but you can use SQL Server 2005/2008 Express Profiler instead.
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