sp_blitzCache results Memory grants The Next CEO of Stack OverflowOptimising plans with XML readersBuffer Cache Size when Page Life Expectancy DropsError running sp_BlitzCache (v5.2)sp_BlitzCache errorsp_BlitzCache install syntax errorssp_BlitzCache slow results on @SortOrder='cpu'sp_BlitzCache Fails When writing to TableSQL Server 2016 - ReportServer - sp_BlitzCachesp_BlitzCache gives a “divide by zero error encountered.”sp_blitzCache against one stored procedure

How does the mv command work with external drives?

What exact does MIB represent in SNMP? How is it different from OID?

How do I go from 300 unfinished/half written blog posts, to published posts?

Inappropriate reference requests from Journal reviewers

Why do we use the plural of movies in this phrase "We went to the movies last night."?

What happens if you roll doubles 3 times then land on "Go to jail?"

Won the lottery - how do I keep the money?

What's the best way to handle refactoring a big file?

Interfacing a button to MCU (and PC) with 50m long cable

How to invert MapIndexed on a ragged structure? How to construct a tree from rules?

Between two walls

Should I tutor a student who I know has cheated on their homework?

Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?

Which tube will fit a -(700 x 25c) wheel?

If the heap is initialized for security, then why is the stack uninitialized?

Why don't programming languages automatically manage the synchronous/asynchronous problem?

Can I equip Skullclamp on a creature I am sacrificing?

Why does the UK parliament need a vote on the political declaration?

How did people program for Consoles with multiple CPUs?

Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?

How to start emacs in "nothing" mode (`fundamental-mode`)

Is there an analogue of projective spaces for proper schemes?

How do we know the LHC results are robust?

Is it my responsibility to learn a new technology in my own time my employer wants to implement?



sp_blitzCache results Memory grants



The Next CEO of Stack OverflowOptimising plans with XML readersBuffer Cache Size when Page Life Expectancy DropsError running sp_BlitzCache (v5.2)sp_BlitzCache errorsp_BlitzCache install syntax errorssp_BlitzCache slow results on @SortOrder='cpu'sp_BlitzCache Fails When writing to TableSQL Server 2016 - ReportServer - sp_BlitzCachesp_BlitzCache gives a “divide by zero error encountered.”sp_blitzCache against one stored procedure










1















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 pages (in the millions) that need to be reduced.



The odd thing is that none of these queries are returning any information for the memory grant columns, they are all null.



Why is that we can have a query returned from sp_BlitzCache doing many reads and writes, but contain nulls for all memory grant columns?



Thanks,
Kevin






sql-server-2012 sp-blitzcache







share|improve this question


























    1















    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 pages (in the millions) that need to be reduced.



    The odd thing is that none of these queries are returning any information for the memory grant columns, they are all null.



    Why is that we can have a query returned from sp_BlitzCache doing many reads and writes, but contain nulls for all memory grant columns?



    Thanks,
    Kevin






    sql-server-2012 sp-blitzcache







    share|improve this question
























      1












      1








      1








      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 pages (in the millions) that need to be reduced.



      The odd thing is that none of these queries are returning any information for the memory grant columns, they are all null.



      Why is that we can have a query returned from sp_BlitzCache doing many reads and writes, but contain nulls for all memory grant columns?



      Thanks,
      Kevin






      sql-server-2012 sp-blitzcache







      share|improve this question














      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 pages (in the millions) that need to be reduced.



      The odd thing is that none of these queries are returning any information for the memory grant columns, they are all null.



      Why is that we can have a query returned from sp_BlitzCache doing many reads and writes, but contain nulls for all memory grant columns?



      Thanks,
      Kevin






      sql-server-2012 sp-blitzcache




      sql-server-2012 sp-blitzcache






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 3 hours ago









      kevinnwhatkevinnwhat

      182




      182




















          1 Answer
          1






          active

          oldest

          votes


















          4














          Those columns only become available on SQL Server 2012 if it's patched up to Service Pack 3.



          Specifically:




          Update for Dm_exec_query_stats DMV to track memory grants information
          in SQL Server 2012




          And KB 3107398.



          Just as an FYI, if you're not on Service Pack 4, you're out of Microsoft support.






          share|improve this answer























            Your Answer








            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "182"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: false,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: null,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f233545%2fsp-blitzcache-results-memory-grants%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            4














            Those columns only become available on SQL Server 2012 if it's patched up to Service Pack 3.



            Specifically:




            Update for Dm_exec_query_stats DMV to track memory grants information
            in SQL Server 2012




            And KB 3107398.



            Just as an FYI, if you're not on Service Pack 4, you're out of Microsoft support.






            share|improve this answer



























              4














              Those columns only become available on SQL Server 2012 if it's patched up to Service Pack 3.



              Specifically:




              Update for Dm_exec_query_stats DMV to track memory grants information
              in SQL Server 2012




              And KB 3107398.



              Just as an FYI, if you're not on Service Pack 4, you're out of Microsoft support.






              share|improve this answer

























                4












                4








                4







                Those columns only become available on SQL Server 2012 if it's patched up to Service Pack 3.



                Specifically:




                Update for Dm_exec_query_stats DMV to track memory grants information
                in SQL Server 2012




                And KB 3107398.



                Just as an FYI, if you're not on Service Pack 4, you're out of Microsoft support.






                share|improve this answer













                Those columns only become available on SQL Server 2012 if it's patched up to Service Pack 3.



                Specifically:




                Update for Dm_exec_query_stats DMV to track memory grants information
                in SQL Server 2012




                And KB 3107398.



                Just as an FYI, if you're not on Service Pack 4, you're out of Microsoft support.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 3 hours ago









                Erik DarlingErik Darling

                22.4k1269111




                22.4k1269111



























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Database Administrators Stack Exchange!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid …


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f233545%2fsp-blitzcache-results-memory-grants%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    -

                    Popular posts from this blog

                    Are there any AGPL-style licences that require source code modifications to be public? Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Force derivative works to be publicAre there any GPL like licenses for Apple App Store?Do you violate the GPL if you provide source code that cannot be compiled?GPL - is it distribution to use libraries in an appliance loaned to customers?Distributing App for free which uses GPL'ed codeModifications of server software under GPL, with web/CLI interfaceDoes using an AGPLv3-licensed library prevent me from dual-licensing my own source code?Can I publish only select code under GPLv3 from a private project?Is there published precedent regarding the scope of covered work that uses AGPL software?If MIT licensed code links to GPL licensed code what should be the license of the resulting binary program?If I use a public API endpoint that has its source code licensed under AGPL in my app, do I need to disclose my source?

                    Image
                    Flight departed from the gate 5 min before scheduled departure time. Refund options How to show a density matrix is in a pure/mixed state? Can we cancel the equality mark here? How to ask rejected full-time candidates to apply to teach individual courses? Are there any AGPL-style licences that require source code modifications to be public? Why did Israel vote against lifting the American embargo on Cuba? What should one know about term logic before studying propositional and predicate logic? Why is Rajasthan pro BJP in the LS elections but not in the state elections? New Order #6: Easter Egg Question on Gÿongy' lemma proof How to resize main filesystem Is it OK if I do not take the receipt in Germany? My mentor says to set image to Fine instead of RAW — how is this different from JPG? Can I feed enough spin up electron to a black hole to affect it's angular momentum? How do I find my Spellcasting Ability for my D&D character? Is my guitar...
                    Read more

                    2013 GY136 Descoberta | Órbita | Referências Menu de navegação«List Of Centaurs and Scattered-Disk Objects»«List of Known Trans-Neptunian Objects»

                    Image
                    Objetos do disco dispersoObjetos transnetunianos objeto transnetunianodisco dispersoSistema Solarcorpo celesteressonância orbitalplanetaplanetamagnitude absolutadiâmetro9 de abril2013Outer Solar System Origins Surveyórbitaexcentricidadesemieixo maiorUAperiélioSolafélio 2013 GY136 Data da descoberta 9 de abril de 2013 Descoberto por Outer Solar System Origins Survey Categoria Transnetuniano Objeto do disco disperso Elementos orbitais Semieixo maior 55,961 UA Perélio 32,595 UA Afélio 79,327 UA Excentricidade 0,418 Inclinação 10,9° Características físicas Dimensões 133 km Magnitude absoluta 7,6 ver 2013 GY 136 , também escrito como 2013 GY136 , é um objeto transnetuniano que está localizado no disco disperso, uma região do Sistema Solar. Este corpo celeste está em uma ressonância orbital de 2:5 com o planeta planeta. Ele possui uma magnitude absoluta de 7,6 [ 1 ] e tem um diâmetro estimad...
                    Read more

                    Mortes em março de 2019 Referências Menu de navegação«Zhores Alferov, Nobel de Física bielorrusso, morre aos 88 anos - Ciência»«Fallece Rafael Torija, o bispo emérito de Ciudad Real»«Peter Hurford dies at 88»«Keith Flint, vocalista do The Prodigy, morre aos 49 anos»«Luke Perry, ator de 'Barrados no baile' e 'Riverdale', morre aos 52 anos»«Former Rangers and Scotland captain Eric Caldow dies, aged 84»«Morreu, aos 61 anos, a antiga lenda do wrestling King Kong Bundy»«Fallece el actor y director teatral Abraham Stavans»«In Memoriam Guillaume Faye»«Sidney Sheinberg, a Force Behind Universal and Spielberg, Is Dead at 84»«Carmine Persico, Colombo Crime Family Boss, Is Dead at 85»«Dirigent Michael Gielen gestorben»«Ciclista tricampeã mundial e prata na Rio 2016 é encontrada morta em casa aos 23 anos»«Pagan Community Notes: Raven Grimassi dies, Indianapolis pop-up event cancelled, Circle Sanctuary announces new podcast, and more!»«Hal Blaine, Wrecking Crew Drummer, Dies at 90»«Morre Coutinho, que editou dupla lendária com Pelé no Santos»«Cantor Demétrius, ídolo da Jovem Guarda, morre em SP»«Ex-presidente do Vasco, Eurico Miranda morre no Rio de Janeiro»«Bronze no Mundial de basquete de 1971, Laís Elena morre aos 76 anos»«Diretor de Corridas da F1, Charlie Whiting morre aos 66 anos às vésperas do GP da Austrália»«Morreu o cardeal Danneels, da Bélgica»«Morreu o cartoonista Augusto Cid»«Morreu a atriz Maria Isabel de Lizandra, de "Vale Tudo" e novelas da Tupi»«WS Merwin, prize-winning poet of nature, dies at 91»«Atriz Márcia Real morre em São Paulo aos 88 anos»«Mauritanie: décès de l'ancien président Mohamed Mahmoud ould Louly»«Morreu Dick Dale, o rei da surf guitar e de "Pulp Fiction"»«Falleció Víctor Genes»«João Carlos Marinho, autor de 'O Gênio do Crime', morre em SP»«Legendary Horror Director and SFX Artist John Carl Buechler Dies at 66»«Morre em Salvador a religiosa Makota Valdina»«مرگ بازیکن‌ سابق نساجی بر اثر سقوط سنگ در مازندران»«Domingos Oliveira morre no Rio»«Morre Airton Ravagniani, ex-São Paulo, Fla, Vasco, Grêmio e Sport - Notícias»«Morre o escritor Flavio Moreira da Costa»«Larry Cohen, Writer-Director of 'It's Alive' and 'Hell Up in Harlem,' Dies at 77»«Scott Walker, experimental singer-songwriter, dead at 76»«Joseph Pilato, Day of the Dead Star and Horror Favorite, Dies at 70»«Sheffield United set to pay tribute to legendary goalkeeper Ted Burgin who has died at 91»«Morre Rafael Henzel, sobrevivente de acidente aéreo da Chapecoense»«Morre Valery Bykovsky, um dos primeiros cosmonautas da União Soviética»«Agnès Varda, cineasta da Nouvelle Vague, morre aos 90 anos»«Agnès Varda, cineasta francesa, morre aos 90 anos»«Tania Mallet, James Bond Actress and Helen Mirren's Cousin, Dies at 77»e

                    Image
                    Mortos em 2019Eventos de março de 2019 ←JaneiroFevereiroMarçoAbrilMaioJunhoJulhoAgostoSetembroOutubroNovembroDezembro→https://g1.globo.com/pop-arte/noticia/2019/04/01/rapper-nipsey-hussle-e-morto-a-tiros-em-los-angeles.ghtml Mortes em 2019 : ← Janeiro – Fevereiro – Março – Abril – Maio – Junho – Julho – Agosto – Setembro – Outubro – Novembro – Dezembro → Está é uma relação de pessoas notáveis que morreram durante o mês de março de 2019, listando nome, nacionalidade, ocupação e ano de nascimento. Keith Flint , músico inglês. Luke Perry , ator e dublador americano. Coutinho , futebolista brasileiro. Eurico Miranda , dirigente esportivo e político brasileiro. Charlie Whiting , diretor de provas britânico. Valery Bykovsky , cosmonauta russo. Agnès Varda , cineasta belgo-francesa. Dia Nome Profissão ou motivo de...
                    Read more