SQL Server Cache and Stored Procedure Recompilations - Microsoft SQL Server 2012 Performance Tuning - page 188

12. Now, switch to SQL Server Profiler, and you should see the trace window with the
trace events shown in following screenshot:
How it works...
We first started with an SQL Trace, with Blank template, and included the following events:
F Stored Procedures
SP:Completed
SP:Recompile
SP:Starting
F TSQL
SQL:StmtCompleted
SQL:StmtRecompile
SQL:StmtStarting
In this recipe, we have new events— SP:Recompile and SQL:StmtRecompile . The
SP:Recompile trace event indicates the recompilation of whole stored procedure, whereas
the SQL:StmtRecompile event indicates the recompilation of individual SQL statements.