Overview Run SQL Server Profiler SQL Server Profiler Templates and Permissions SQL Server Profiler Templates Create a Trace Template Modify Trace Templates Derive a Template from a Running Trace Derive a Template from a Trace File or Trace Table Export a Trace Template Import a Trace Template Permissions Required to Run SQL Server Profiler Set Global Trace Options Set Trace Definition Defaults Set Trace Display Defaults Create a Trace Create a Transact-SQL Script for Running a Trace Start a Trace Start a Trace Automatically after Connecting to a Server Find a Value or Data Column While Tracing Organize Columns Displayed in a Trace Extract a Script from a Trace Pause a Trace Stop a Trace Run a Trace After It Has Been Paused or Stopped Clear a Trace Window Close a Trace Window View and Analyze Traces with SQL Server Profiler Analyze Deadlocks with SQL Server Profiler Analyze Queries with SHOWPLAN Results in SQL Server Profiler Correlate a Trace with Windows Performance Log Data Filter Traces with SQL Server Profiler Filter Events in a Trace View Filter Information Modify a Filter Filter Events Based on the Event Start Time Filter Events Based on the Event End Time Filter Server Process IDs (SPIDs) in a Trace Save Traces and Trace Templates Save Trace Results to a File Set a Maximum File Size for a Trace File Specify Events and Data Columns for a Trace File Save Trace Results to a Table Set a Maximum Table Size for a Trace Table Open a Trace File Open a Trace Table Replay Traces Replay Requirements Replay Options Considerations for Replaying Traces Replay a Trace Table Replay a Trace File Replay a Single Event at a Time Replay to a Breakpoint Replay to a Cursor Replay a Transact-SQL Script SQL Server Profiler dialog boxes