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.

Enter the SQL Profiler. This monitoring tool is designed to trace any activity that occurs on a SQL Server database server.

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.