databasejournal.com databasejournal.com

Identifying Stored Procedure Recompilation Problems in SQL Server 2000 - Page 4

Using the Profiler to Watch Recompile Events The Profiler Video The SQL Profiler captures events as they occur inside the SQL Server engine. Recompilation of a stored procedure triggers the event SP:Recompile. It is the most relevant event to monitor. There are are also related events that you will want to watch at the same time. When monitoring recompilation I suggest that you watch the events shown in Figure 3. Figure 3...