MSSQLTips

arunraj_c, Thank you for the posting. This could be a good tip. If you were interested we would be interested in seeing a comparision and contrast with the version of Profiler from Microsoft that ships with the Standard or Enterprise Edition. Let us know if you would be interested. Thank you, The MSSQLTips...

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