Question : I’m experiencing almost instant plan cache clean up. No plan resides in the plan cache for more than […]
Tag: plan-cache
SQL Server cached an execution plan which is not optimal in some cases and uses it for all consequent queries
Question : Our application uses SQL Server 2014 and we got an issue related to the plan cache. We have […]
sp_Blitzcache doesn’t return as many results as sys.dm_exec_query_stats for a given query
Question : I am trying to find plans for a particular set of queries (those that update MyTable) using sp_blitzcache: […]
Is it possible to get the name of a procedure by it’s plan handle or query plan hash if the execution plan is already cleared from the plan cache?
Question : I ran a home-brew trace for the length of 1 day that captured a few things that were […]
Will cleaning data cache help to resolve compiler memory pressure?
Question : I currently experience RESOURCE_SEMAPHORE_QUERY_COMPILE waits causing CPU spike 100% that lasts 10-20 mins and disappears only by completely […]
Can we set the fixed size for both plan cache and data cache?
Question : As far as I know, SQL Server automatically manages the size for the components of buffer pool. I […]
Finding Serial plan from Plan cache
Question : My application goes slow sometimes and when i check the query plan plan for a particular operation,i see […]
Parameterized query creating many plans
Question : I have some queries that are parameterized, but they are still creating a new execution plan each time. […]
What happens when a stored procedure executes one of two different queries based on an input parameter?
Question : I have encountered a stored procedure that performs one of two different queries based on an input parameter. […]
Query the plan cache for scan and seek operations for a particular index
Question : Can you please help me in querying the plan cache in order to see which queries perform a […]