Opening SQL Server Profiler from SSMS


The new Activity Monitor has another trick up its sleeve: If you open it and then expand the first band of information just below the four graphs, you’ll see a list of processes that you can order, sort and filter. If you right-click any process, you’ll see an option to "open in Profiler". Click that, and you’ll open Profiler with a default trace right on that SPID. Very useful to quickly identify the actions of a connection.

Comments (2)

  1. Saggi Neumann says:

    There’s also the option to set a trace on the current query window (that is, current SPID) through the context menu – however, it doesn’t look like the events/columns picked automatically are related to the default trace template. Is there a way to configure this trace’s events and columns?

    Thanks,

    S. Neumann