Question : I am trying to find plans for a particular set of queries (those that update MyTable) using sp_blitzcache: […]
Tag: sp-blitzcache
sp_BlitzCache slow results on @SortOrder=’cpu’
Question : I’ve been using sp_BlitzCache to investigate a few problems with a DB of mine for a few days. […]
Sp_BlitzCache 678 not writing to table
Question : Version 678 from github is displaying results in SSMS query window as expected but not creating a table, […]
Error when I run sp_BlitzCache specifying an output db, schema, and table
Question : I am using sp_BlitzCache version 4.1 (20161210) and executing it on a 2008R2 instance (10.5.4042). If I execute […]
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 […]
Error running sp_BlitzCache (v5.2)
Question : I’ve installed sp_BlitzCache (and others) from the First Responder Kit, and I am receiving the following error: EXEC […]
sp_BlitzCache slow results on @SortOrder=’cpu’
Question : I’ve been using sp_BlitzCache to investigate a few problems with a DB of mine for a few days. […]
sp_BlitzCache and SPID
Question : I’m using sp_BlitzCache and it’s very helpful, I ran this command: Sp_BlitzCache @SortOrder = ‘duration’; GO How do […]
Most of the query plans recreated in the past 4 hours
Question : I have got a problem with my SQL Server database’s performance. I have found this tool sp_BlitzCache. After […]
sp_BlitzCache doesn’t monitor databases under availability group
Question : I’m using the latest version of sp_BlitzCache to capture some performance issues and slow runnig queries, but it […]
- 1
- 2