Opening SQL Server Profiler from SSMS

Rate This
  • Comments 2

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.

Leave a Comment
  • Please add 6 and 3 and type the answer here:
  • Post
Page 1 of 1 (2 items)