United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Database Engine Features and Tasks

Database Engine Instances (SQL Server)

SQL Server Profiler

SQL Server Profiler Templates and Permissions

Run SQL Server Profiler

Create a Trace (SQL Server Profiler)

Specify Events and Data Columns for a Trace File (SQL Server Profiler)

Save Trace Results to a File (SQL Server Profiler)

Save Trace Results to a Table (SQL Server Profiler)

Filter Events in a Trace (SQL Server Profiler)

View Filter Information (SQL Server Profiler)

Modify a Filter (SQL Server Profiler)

Set a Maximum File Size for a Trace File (SQL Server Profiler)

Set a Maximum Table Size for a Trace Table (SQL Server Profiler)

Start a Trace

Start a Trace Automatically after Connecting to a Server (SQL Server Profiler)

Filter Events Based on the Event Start Time (SQL Server Profiler)

Filter Events Based on the Event End Time (SQL Server Profiler)

Filter Server Process IDs (SPIDs) in a Trace (SQL Server Profiler)

Pause a Trace (SQL Server Profiler)

Stop a Trace (SQL Server Profiler)

Run a Trace After It Has Been Paused or Stopped (SQL Server Profiler)

Clear a Trace Window (SQL Server Profiler)

Close a Trace Window (SQL Server Profiler)

Set Trace Definition Defaults (SQL Server Profiler)

Set Trace Display Defaults (SQL Server Profiler)

Open a Trace File (SQL Server Profiler)

Open a Trace Table (SQL Server Profiler)

Replay a Trace Table (SQL Server Profiler)

Replay a Trace File (SQL Server Profiler)

Replay a Single Event at a Time (SQL Server Profiler)

Replay to a Breakpoint (SQL Server Profiler)

Replay to a Cursor (SQL Server Profiler)

Replay a Transact-SQL Script (SQL Server Profiler)

Create a Trace Template (SQL Server Profiler)

Modify a Trace Template (SQL Server Profiler)

Set Global Trace Options (SQL Server Profiler)

Find a Value or Data Column While Tracing (SQL Server Profiler)

Derive a Template from a Running Trace (SQL Server Profiler)

Derive a Template from a Trace File or Trace Table (SQL Server Profiler)

Create a Transact-SQL Script for Running a Trace (SQL Server Profiler)

Export a Trace Template (SQL Server Profiler)

Import a Trace Template (SQL Server Profiler)

Extract a Script from a Trace (SQL Server Profiler)

Correlate a Trace with Windows Performance Log Data (SQL Server Profiler)

Organize Columns Displayed in a Trace (SQL Server Profiler)

Start SQL Server Profiler

Save Traces and Trace Templates

Modify Trace Templates

Correlate a Trace with Windows Performance Log Data

View and Analyze Traces with SQL Server Profiler

Analyze Deadlocks with SQL Server Profiler

Analyze Queries with SHOWPLAN Results in SQL Server Profiler

Filter Traces with SQL Server Profiler

Replay Traces

SQL Server Profiler F1 Help

Minimize

7 out of 22 rated this helpful - Rate this topic

Run SQL Server Profiler

SQL Server 2012

To run SQL Server Profiler, on the Start menu, point to All Programs, Microsoft SQL Server 2012, Performance Tools, and then click SQL Server Profiler.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.