0

I saw several videos where the know procedure sp_blitzfirst shows the memory grant columns, I even saw it working like that, but on the latest version of the first responder kit, it doesn't show those columns, were those removed?

When I execute it with @expertmode=1 it just show on the messages tab:

Setting up configuration variables 
Now starting diagnostic analysis 
Capturing first pass of wait stats, perfmon counters, file stats 
Beginning investigatory queries 
Finished running investigatory queries 
Waiting to match @Seconds parameter 
Capturing second pass of wait stats, perfmon counters, file stats 
Analyzing changes between first and second passes of DMVs 
Analysis finished, outputting results

1 Answer 1

0

Do you perhaps need to use sp_BlitzCache instead?

In the source code for sp_BlitzFirst is the line:

Run sp_BlitzCache @SortOrder = 'memory grant' to find queries with huge memory grants and tune them.

On July 14, 2016, the following changes were made (commit 62b6e9df):

Put all of the what’s running now work inside an IF statement so it only runs if we’re in ExpertMode (to minimize executions, since this proc needs to go fast under load.) Cleaned up some of the “memory not granted” and “memory already granted” stuff to just be N/A since it can mean different things depending on whether the query needs memory.

2
  • Thanks Randolph, yes I see that sp_blitzcache does have that information. But my question was related to the fact that sp_blitzfirst used to print that column and now it seems to be missing. Commented Feb 9, 2018 at 18:18
  • See updated answer. Commented Feb 9, 2018 at 18:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.