Question : Can you please help me in querying the plan cache in order to see which queries perform a […]
Tag: plan-cache
Questions about DBCC FREEPROCCACHE
Question : I used spAskBrent for troubleshooting a SQL Server 2005 performance issue. I found the problem was someone had […]
How to query cached plans that contain a specific missing index?
Question : I see a potential missing index for a table but would like to first query all cached plans […]
Missing execution plans for stored procedures
Question : What are the reasons for a plan to be missing from cache for stored procedures? WITH RECOMPILE Dynamic […]
High CPU and plan cache instability
Question : In the past couple of months my SQL Server instance has been experiencing higher than usual CPU usage […]
How to regenerate execution plans after clearing the plan cache?
Question : After clearing the plan cache on SQL Server, how do I regenerate execution plans for stored procedures without […]
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. […]
SQL Server Plan cache size only 4GB on a server with 500GB RAM
Question : I have a SQL server 2016 SP1 that has been up and running over a year and using […]
Run sp_BlitzCache an agent job to assist performance tuning efforts / baselining query performance?
Question : Just getting into using various Brent Ozar tools like sp_BlitzCache and sp_BlitzIndex to identify and correct SQL Server […]
Slow Query with RESOURCE_SEMAPHORE wait info [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]