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.
In This Section
| 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. |
See Also
Other Resources
Introducing SQL Server Profiler