Where is SQL Profiler in my SQL Server 2008?

sql-server sql-server-profiler profiling
mrblah picture mrblah · Mar 11, 2009 · Viewed 114.5k times · Source

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?

Answer

Mitch Wheat picture Mitch Wheat · Mar 11, 2009

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

Related questions

SQL Server Profiler - How to filter trace to only display events from one database?

How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the trace to not see events for all databases on the instance I connect to.

Read More
What does "exec sp_reset_connection" mean in Sql Server Profiler?

Trying to understand what Sql Profiler means by emitting "sp_reset_connection". I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed, RPC:Completed exec sp_reset_connection SQL:BatchStarting SELECT [c].[TestID] AS [TestID], [c].[…

Read More
Unit of measurement for Duration column in SQL Profiler

What is the unit of the Duration column in SQL Profiler? I thought it was milliseconds but in the following Profiler row I found it contradicting with start and end time: spid=163 duration=11310646 starttime=2010-04-06 17:45:24.480 endtime=2010-04-06 17:45:35.790 reads=152 …

Read More