• SQL-DBA-01 - Monday, March 27, 2017 3:24 PM

    Is there any possibility to read from extended events to find when recompile occurred sql server @procedure level?

    Don't think you can do this after the fact - don't see anything in system_health.
    You can create a session to monitor for recompiles using the event sql_statement_recompile. If you want to filter on just stored procedures, filter object_type = proc

    Sue