Microsoft® SQL Server 2012 Unleashed

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 require and how you want the information grouped. For example, if you want to see the SQL statements that each user is submitting through an application, you could trace incoming SQL statements and group them by user and by application.

When you have an idea about what you want to trace, you should launch the SQL Server Profiler by selecting Start, then Microsoft SQL Server 2012, then Performance Tools, and finally SQL Server Profiler. You can also launch it from within SSMS from the Tools menu. When you launch the Profiler, the first window to appear allows you to enter ...