Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sp-blitzcache]

For questions about the SQL Server plan cache analysis script by the Brent Ozar Unlimited team

29 questions
11
votes
2 answers

Most of the query plans recreated in the past 4 hours

I have got a problem with my SQL Server database's performance. I have found this tool sp_BlitzCache. After command's executing, I got this statement: You have 92.00% plans created in the past 24 hours, and 92.00% created in the past 4…
Marcin Topolewski
  • 111
  • 7
6
votes
2 answers

Can a server wide setting of 'Max Degree of Parallelism' = 1 cause Brent Ozar's sp_BlitzCache to flag execution plan as 'forced-serialization'?

I am using Brent Ozar's sp_BlitzCache store procedure and I'm attempting to nail down why it is reporting: "Something in your plan is forcing a serial query. Further investigation is needed if this is not by design." Upon investigation I found…
D-K
  • 543
  • 1
  • 5
  • 17
6
votes
1 answer

sp_BlitzCache slow results on @SortOrder='cpu'

I've been using sp_BlitzCache to investigate a few problems with a DB of mine for a few days. It's been a huge help, but just today it started acting a little odd and I'm curious if anyone has any ideas what's up. Yesterday I ran many checks with…
Guy
  • 63
  • 5
4
votes
1 answer

sp_BlitzCache gives a "divide by zero error encountered."

After updating to First Responders Kit 20180901, I have a job that runs every 15 minutes and calls sp_BlitzFirst: EXEC [DBA Maintenance].[dbo].[sp_BlitzFirst] @OutputDatabaseName = 'DBA Maintenance', @OutputSchemaName = 'dbo', …
Matthew Brook
  • 41
  • 1
3
votes
2 answers

Parameter Sniffing and Multiple Plans in Cache

We have a multi-tenanted database. FirmID is the partition key and we have lots of different firms. I am running into a parameter sniffing issue and I am having a heck of a time getting around it. I would rather not use any [Options] on the…
Joshua Grippo
  • 140
  • 1
  • 9
3
votes
1 answer

sp_blitzCache results Memory grants

I am running SQL Server 2012 and and using the March 2019 release of sp_blitzCache to analyze some slow running queries on the system. I have executed the stored procedure with parameter @SortOrder = 'Reads' and found some queries reading tons of…
kevinnwhat
  • 2,224
  • 1
  • 10
  • 21
3
votes
1 answer

sp_blitzCache against one stored procedure

Recently we started using sp_BlitzCache to help us tune our queries. We found one SP that had some issues with it and we were able to refactor it successfully. I have a copy of the output of sp_BlitzCache taken during the week before we tuned the…
kevinnwhat
  • 2,224
  • 1
  • 10
  • 21
2
votes
1 answer

sp_Blitzcache doesn't return as many results as sys.dm_exec_query_stats for a given query

I am trying to find plans for a particular set of queries (those that update MyTable) using sp_blitzcache: EXEC sp_Blitzcache @SlowlySearchPlansFor = 'UPDATE [My Table]' this returns 3 results, however, when I run the following query SELECT …
SE1986
  • 2,142
  • 4
  • 30
  • 61
2
votes
1 answer

Occasional error when running sp_BlitzFirst

I have set up sp_BlitzFirst to run as a job (for the PowerBI Dashboard). Occasionally, when it runs, it gets the following error: Msg 8152, Sev 16, State 13, Line 2980 : String or binary data would be truncated. [SQLSTATE 22001] This is actually…
Darrell
  • 125
  • 3
  • 10
2
votes
1 answer

sp_BlitzCache install syntax errors

Trying to install sp_BlitzCache on SQL Server 2008, I get: Msg 102, Level 15, State 1, Procedure sp_BlitzCache, Line 2705 Incorrect syntax near '.'. Msg 102, Level 15, State 1, Procedure sp_BlitzCache, Line 2715 Incorrect syntax near '.'. Msg 102,…
pkemner
  • 23
  • 3
2
votes
1 answer

Error running sp_BlitzCache (v5.2)

I've installed sp_BlitzCache (and others) from the First Responder Kit, and I am receiving the following error: EXEC sp_BlitzCache; Msg 208, Level 16, State 0, Procedure sp_BlitzCache, Line 3878 [Batch Start Line 0] Invalid object name…
Brad C.
  • 131
  • 2
2
votes
1 answer

Error when I run sp_BlitzCache specifying an output db, schema, and table

I am using sp_BlitzCache version 4.1 (20161210) and executing it on a 2008R2 instance (10.5.4042). If I execute the sp without the @OutputDatabaseName, @OutputSchemaName, and @OutputTableName, it works fine. However, when I set those values, it…
SQL_Hacker
  • 531
  • 4
  • 15
2
votes
1 answer

Sp_BlitzCache 678 not writing to table

Version 678 from github is displaying results in SSMS query window as expected but not creating a table, using the following commands: USE DBAResources; GO EXEC dba.sp_BlitzCache @Top=10, @OutputDatabaseName = 'DBAResources', @OutputTableName =…
Nicole G.
  • 315
  • 2
  • 4
1
vote
1 answer

Interpreting sp_BlitzCache: # Executions but since when?

I'm getting started with sp_BlitzCache (which is amazing!) and trying to understand the results better. When does the # Executions count from? e.g. if it says 343 executions is that today, since server start, or what? I'm running it like…
Rory
  • 1,330
  • 9
  • 12
1
vote
0 answers

SQL Server 2016 - ReportServer - sp_BlitzCache

Does it ever make sense to try to tune queries in the ReportServer database behind SSRS? Diagnostic tools such as sp_BlitzCache indicate possible issues, but I've a tendency not to futz with that particular database. Any suggestions?
Steve_Malcolm
  • 135
  • 3
  • 10
1
2