CREATING A TRACE TO IDENTIFY SLOW RUNNING QUERIES
SQL Server Profiler is an interface to create and manage traces and analyze and replay trace results. Events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.
In this post we will see how to create a trace to capture slow running queries using profiler.