Questions tagged [sp-blitzcache]
For questions about the SQL Server plan cache analysis script by the Brent Ozar Unlimited team
28
questions
-1
votes
1
answer
124
views
sp_BlitzCache detecting thousands of executions of CREATE PROCEDURE dbo.CommandExecute (from Ola Hallengren's Maintenance Solution) [duplicate]
I recently implemented the Maintenance Solution as a nightly job in my company's database, via Windows Scheduler. It works as intended, except for one issue - the procedures are being created ...
- 109
0
votes
2
answers
72
views
sp_BlitzCache and encrypted procedure
I went on to run sp_BlitzCache in a production SQL Server 2014 server and I can see the procedures displayed, being reported as:
"We couldn't find a plan for this query."
I have a feeling ...
- 501
0
votes
1
answer
159
views
sp_BlitzCache and SPID
I'm using sp_BlitzCache and it's very helpful, I ran this command:
Sp_BlitzCache @SortOrder = 'duration';
GO
How do you relate the query with a SPID as I found the query with the longest duration? So ...
- 79
0
votes
1
answer
99
views
sp_BlitzCache doesn't monitor databases under availability group
I'm using the latest version of sp_BlitzCache to capture some performance issues and slow runnig queries, but it seems the sp doesn't check or monitor databases that belong to an availability group, ...
- 409
6
votes
2
answers
619
views
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 ...
- 463
3
votes
2
answers
798
views
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 ...
- 140
0
votes
2
answers
109
views
How to query cached plans that contain a specific missing index?
I see a potential missing index for a table but would like to first query all cached plans that have that specific missing index (so I can later test those queries after the new index is built). How ...
- 1,066
1
vote
1
answer
260
views
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 ...
- 1,280
2
votes
1
answer
233
views
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, ...
- 1,741
0
votes
0
answers
125
views
many of the same queries on the query plan - whats the pros and cons of Forced Parameterization in this scenario?
while working on finding all the queries in the query plan that are related to a particular index I realised that there were too many duplicates of the same queries on the query plan.
Finding what ...
- 15.6k
0
votes
1
answer
49
views
sp_BlitzCache and cursors
I'm running sp_BlitzCache (Brent Ozar) to get some information about database performance. The program that "attacks" this database uses cursors everywhere, so sp_BlitzCache gives me several lines ...
- 31
3
votes
1
answer
167
views
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 = ...
- 2,234
3
votes
1
answer
2k
views
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 ...
- 2,234
0
votes
2
answers
499
views
Can sp_Blitz, sp_BlitzCache, or sp_BlitzFirst identify what queries caused a major growth operation to occur on a particular log file?
I'm currently logging the outputs of sp_Blitz, sp_BlitzCache, and sp_BlitzFirst regularly (via SQL jobs).
A particular database's log file grew somewhat exponentially and I believe I can see the ...
- 32k
4
votes
1
answer
280
views
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 ...
1
vote
0
answers
53
views
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 ...
- 135
1
vote
1
answer
57
views
sp_BlitzCache throws Table DML warning on temp tables
I have been using sp_BlitzCache to troubleshoot some performance issues on a client's SQL Server 2012 instance. I am running:
EXEC sp_BlitzCache @ExpertMode=1, @SortOrder = 'reads';
And one of the ...
- 123
1
vote
1
answer
1k
views
SQL Server sp_BlitzCache - Many Plans for One Query
I'm in need of a bit of assistance.
I ran sp_Blitz on one of my SQL Servers and one of the results it returned is "1531 plans are present for a single query in the plan cache - meaning we probably ...
- 133
2
votes
1
answer
64
views
Occasional error when running sp_BlitzFirst [closed]
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 ...
- 129
1
vote
0
answers
217
views
sp_BlitzCache Fails When writing to Table
I'm attempting to run sp_blitzcache version 5.8 on sql server 2012 SP3 with following parameters:
EXEC sp_BlitzCache @SortOrder = 'CPU',
@Top = 10,
@ExpertMode =...
- 11
1
vote
2
answers
3k
views
SQL maximum memory limit exceeded
Microsoft SQL Server 2016 (SP1) (KB3182545)
Server Memory : 61GB SQL
Server Max Memory : 56320 MB
I have three database (OneDB,TwoDB,ThreeDB) in the my production environment.
I ...
- 1,071
5
votes
1
answer
706
views
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 ...
- 53
2
votes
1
answer
118
views
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 ...
- 23
10
votes
2
answers
2k
views
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 ...
1
vote
1
answer
243
views
sp_BlitzCache error
I've downloaded and installed sp_BlitzCache on my production server but it gave me the following error:
Msg 208, Level 16, State 0, Procedure sp_BlitzCache, Line 1850 [Batch Start Line 0]
Invalid ...
- 13
2
votes
1
answer
656
views
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 [...
- 131
2
votes
1
answer
315
views
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 ...
- 539
2
votes
1
answer
110
views
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, @...
- 305