Why Did a Plan Get Removed From Cache?

,

I was recently asked if we could tell why a plan was removed from cache. If you read this blog, you know what I’m going to say next. I checked the extended events and there are actually two different events that will tell us information about a plan removed from cache; sp_cache_remove and query_cache_removal_statistics. Let’s […]

The post Why Did a Plan Get Removed From Cache? appeared first on Grant Fritchey.

Rate

Share

Share

Rate