Getting Started: Profiler
SQL Server 2005 ships with a powerful user interface tool that can be used to create, manipulate, and manage traces. SQL Server Profiler is the primary starting point for most tracing activity, and thanks to the ease with which it can help you get traces up and running, it is perhaps the most important SQL Server component available for quickly troubleshooting database issues. SQL Server Profiler also adds a few features to the toolset that are not made possible by SQL Trace itself. This section discusses those in addition to the base tracing capabilities.
Profiler Basics
The Profiler tool can be found in the Performance Tools subfolder of the SQL Server 2005 Start Menu folder. Once the tool is started, you will be ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
