enrique_aeo
asked on
Usage Scenarios for Extended Events - Tracking Recompilations
hi experts
i am reading about: Tracking Recompilations
Tracking Recompilations
Query execution plan recompilations occur when a plan in the plan cache is discarded and recompiled. High numbers of plan recompilations might be an indicator of a performance problem, and may cause CPU pressure. Windows performance counters can be used to track overall recompilation counts for an SQL Server instance, but more detail may be needed to investigate further.
but i do not undertstand
Query execution plan recompilations occur when a plan in the plan cache is discarded and recompiled
can you give me an example in T-SQL
i am reading about: Tracking Recompilations
Tracking Recompilations
Query execution plan recompilations occur when a plan in the plan cache is discarded and recompiled. High numbers of plan recompilations might be an indicator of a performance problem, and may cause CPU pressure. Windows performance counters can be used to track overall recompilation counts for an SQL Server instance, but more detail may be needed to investigate further.
but i do not undertstand
Query execution plan recompilations occur when a plan in the plan cache is discarded and recompiled
can you give me an example in T-SQL
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.