Second, SQL Server 2000’s Profiler introduces template files, which replace both the Create Trace Wizard and the storage of trace definitions in the Registry.

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.