Samkry, These events in Profiler are what you need: Stored Procedures and select the SP:Recompile. The a long execution time for a stored procedure does not necessarily mean that it is recompiling. Thank you, The MSSQLTips.com Team