Export (0) Print
Expand All
10 out of 11 rated this helpful - Rate this topic

SQL Server Profiler Reference

SQL Server Profiler is a tool that captures SQL Server events from a server. The 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. SQL Server Profiler is used for activities such as:

  • Stepping through problem queries to find the cause of the problem.

  • Finding and diagnosing slow-running queries.

  • Capturing the series of Transact-SQL statements that lead to a problem. The saved trace can then be used to replicate the problem on a test server where the problem can be diagnosed.

  • Monitoring the performance of SQL Server to tune workloads. For information about tuning the physical database design for database workloads, see Database Engine Tuning Advisor Overview.

  • Correlating performance counters to diagnose problems

SQL Server Profiler also supports auditing the actions performed on instances of SQL Server. Audits record security-related actions for later review by a security administrator.

Topic

Description

Typical Uses of SQL Server Profiler

Contains information about the typical scenarios where you can use SQL Server Profiler.

Starting SQL Server Profiler

Contains information about starting SQL Server Profiler from the Start menu, from SQL Server Management Studio, and from Database Engine Tuning Advisor.

Using SQL Server Profiler Keyboard Shortcuts

Contains information about keyboard shortcuts you can use for SQL Server Profiler.

Space Requirements for SQL Server Profiler

Contains information about how much space that SQL Server Profiler needs in the temp directory to provide tracing services.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.