“Procedure Cache Management” shows:
Reporting on the number of times stored procedures are recompiled.
Tracking the phase that triggered the recompilations: execution time, recompilation, and so on.
Reporting the cause of recompilation: table missing, permissions change, and so on.
