Questions tagged [sp-blitzcache]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
45 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 ...
0
votes
1answer
19 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 ...
3
votes
1answer
87 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
votes
1answer
133 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 ...
0
votes
2answers
69 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 ...
0
votes
0answers
34 views

Is there a “@SkipChecks…” parameter equivalent for sp_BlitzFirst and sp_BlitzCache?

Silly question, how do I skip over certain databases when running sp_BlitzFirst and sp_BlitzCache? I'm on SQL Server 2008 R2 - Enterprise (10.50.4042.0). (I'm not sure how to get the First Responder ...
2
votes
0answers
29 views

How to handle normalizing the concept of a grid, and also plan for data versioning?

I have inherited a database that has a normalized structure, except for its data tables which are aggressively denormalized. Our system mostly renders grids into a browser, and the previous developer ...
4
votes
1answer
216 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
0answers
44 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 ...
1
vote
1answer
47 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 ...
1
vote
1answer
574 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 ...
2
votes
1answer
45 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 ...
1
vote
0answers
98 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 =...
0
votes
2answers
1k 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 ...
5
votes
1answer
323 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 ...
2
votes
1answer
68 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 ...
9
votes
2answers
887 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
1answer
135 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 ...
2
votes
1answer
549 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 [...
2
votes
1answer
131 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 ...
2
votes
1answer
71 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, @...