Microsoft® SQL Server™ 2000 Unleashed, Second Edition

Creating Traces

Because SQL Server Profiler can trace numerous events, it is easy to “get lost” when reading the trace output. You need to roughly determine the information you need and how you want the information grouped. For example, if you want to see the SQL statements that each user is submitting through his application, you could trace incoming SQL statements and group them by user and by application.

The first place you should look when creating a new trace is at the trace templates. These templates contain predefined trace settings that address some common auditing needs. The available trace templates are listed in Table 7.1.

Table 7.1. SQL Profiler Templates

Template	Description
SQLProfilerSP_Counts	Tracks all of the stored procedures ...