One of the more essential SQL Server tools is its trace utility. With it you can view the activity occurring against a SQL Server for diagnostic, informational, and other purposes. Because it lets you ...

You can track this through a Counter Log, import the performance data to the SQL Profiler and view a synchronized graph with your trace. In this way it is easy to spot the deadlocks.

One feature that helps us quickly set up a trace on our current connection is new in SSMS 2008, namely “Trace Query in SQL Server Profiler”. Let’s take a look.