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.
|SQLProfilerSP_Counts||Tracks all of the stored procedures ...|