SQL Server Profiler Reference
SQL Server Profiler is a tool that captures SQL Server 2005 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 Reference.
-
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 |
|---|---|
|
Contains information about the typical scenarios where you can use 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. | |
|
Contains information about keyboard shortcuts you can use for SQL Server Profiler. | |
|
Contains information about how much space that SQL Server Profiler needs in the temp directory to provide tracing services. |
