Stack Overflow
Stack Overflow

Questions tagged [sp-blitz]

9 questions
2
votes
0 answers

Lots of query plans for stored procedure

I built a stored procedure which finds the shortest route in a company with many warehouses. The procedure is heavily used by the system. After many optimizations, including memory optimized tables, if I run sp_BlitzCache, I have 2…
Nițu Alexandru
  • 714
  • 1
  • 11
  • 33
1
vote
1 answer

sp_blitz warns me about a heap (that only have 1 row)

I have just inherrited a "new" SQL Server, and I've run sp_blitz on it. SP_Blitz warns me about a heap that is being actively queried. The table have just 1 row in it. It is a settings table, so no more rows will ever arrive. Will adding a Clustered…
Henrik Staun Poulsen
  • 13,154
  • 4
  • 23
  • 26
0
votes
0 answers

SQL SERVER - TRACEWRITE - How to find out why it would be slow?

I have been looking at the performance of one of our testing environments and the TRACEWRITE is at the top, these waits seems a bit long 1918.8 ms which to seems rather slow? I am running sp_BlitzFirst to give me these details. exec sp_BlitzFirst…
Andrew
  • 2,571
  • 2
  • 31
  • 56
0
votes
2 answers

Error updating Sp_Blitz to the latest version

I run Blitz weekly and on SQL 2008 express server the Blitz result found that i have SP_blitz over 6 month old. When i try to update everything to the latest , this is what i get . Procedure sp_Blitz, Line 3123 Invalid column name…
MJ8
  • 185
  • 4
  • 19
0
votes
1 answer

PWAIT_ALL_COMPONENTS_INITIALIZED and WAIT_XTP_HOST_WAIT high average ms per wait

I ran exec sp_BlitzFirst @SinceStartup = 1, @OutputType = 'Top10' and got the below output. Everything seems good except I dont know what PWAIT_ALL_COMPONENTS_INITIALIZED or WAIT_XTP_HOST_WAIT is and it seems high. Are those concerning and what are…
Mike Flynn
  • 22,342
  • 54
  • 182
  • 341
0
votes
1 answer

Indexaphobia: High Value Missing Index but has dual nonclustered key already

[dbo].[sp_BlitzIndex] is showing a Indexaphobia: High Value Missing Index for this table but the table has a non clustered index on both columns. Is this still needed? INEQUALITY: [TeamId] {int} INCLUDE: [PlayerId] {int}
Mike Flynn
  • 22,342
  • 54
  • 182
  • 341
0
votes
1 answer

Brent Ozar's SQL Check Scripts - Memory/CPU/IO Concerns?

How careful do I need to be using Brent Ozar's free SQL health check scripts on a SQL Server 2016 production machine that's very full and very busy already? Has anyone run into memory, CPU or I/O issues running any of the following? Thanks for any…
MinnRick
  • 45
  • 7
0
votes
1 answer

Error while updating blitz 'Procedure [s p_Blitz], Line xxx Incorrect syntax near 'FROM A'

I am trying to update Blitz to the latest version '7.95', @VersionDate = '20200506'. I get the following error Procedure [s p_Blitz], Line 5863Incorrect syntax near 'FROM A'. The other error i am getting is Procedure [s p Blitz Cache]Line 4814…
MJ8
  • 185
  • 4
  • 19
0
votes
0 answers

SQL Server- Sp_Blitz query executing for more than 5 hours

I am running sp_Blitz on my SQL Server 2014 with 93 databases. It has been running for more than 5 hours and still won't complete. I am able to run sp_BlitzWho,sp_BlitzIndex,sp_BlitzFirst and sp_Blitzbackup and they all take about 2-3 minutes to…
Alekhya
  • 1
  • 2