SQL Profiler Templates
08-Aug-1212 Leave a comment
With a lot of “noise” from hits on the live data I want the ability to see what my development code is hitting for SQL. In this particular case I want to understand the SQL that Entity Framework is generating.
The default location of SQL Profiler templates is (possibly 90 or 100 or other):
C:\Users\<USERNAME>\AppData\Roaming\Microsoft\SQL Profiler\10.0\Templates\Microsoft SQL Server\100
Events to include:
RPC:Completed
Filters:
NTUserName = ‘<>’
ApplicationNameĀ Not Like ‘<>’