TABLE 1: Some Cache Events That Profiler Captures
Event Name Description
SP:CacheMiss Plan not found in cache
SP:CacheInsert New plan inserted in cache
SP:CacheRemove Plan discarded from cache
SP:Recompile Plan is recompiled
SP:CacheHit Plan found in cache
SP:ExecContextHit Execution plan found in cache