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

Skipping indices in a product

Unreliable Magic - Is it worth it?

Why do professional authors make "consistency" mistakes? And how to avoid them?

Inappropriate reference requests from Journal reviewers

Would this house-rule that treats advantage as a +1 to the roll instead (and disadvantage as -1) and allows them to stack be balanced?

Is "for causing autism in X" grammatical?

Anatomically Correct Strange Women In Ponds Distributing Swords

What benefits would be gained by using human laborers instead of drones in deep sea mining?

How does the mv command work with external drives?

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

Why do airplanes bank sharply to the right after air-to-air refueling?

WOW air has ceased operation, can I get my tickets refunded?

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

How to transpose the 1st and -1th levels of arbitrarily nested array?

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

If Nick Fury and Coulson already knew about aliens (Kree and Skrull) why did they wait until Thor's appearance to start making weapons?

Won the lottery - how do I keep the money?

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

How to solve a differential equation with a term to a power?

What expression will give age in years in QGIS?

Non-deterministic sum of floats

What was the first Unix version to run on a microcomputer?

Is there a difference between "Fahrstuhl" and "Aufzug"

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 2 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 2 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

                    Reverse int within the 32-bit signed integer range: [−2^31, 2^31 − 1]Combining two 32-bit integers into one 64-bit integerDetermine if an int is within rangeLossy packing 32 bit integer to 16 bitComputing the square root of a 64-bit integerKeeping integer addition within boundsSafe multiplication of two 64-bit signed integersLeetcode 10: Regular Expression MatchingSigned integer-to-ascii x86_64 assembler macroReverse the digits of an Integer“Add two numbers given in reverse order from a linked list”

                    Image
                    C++ debug of nlohmann json using GDB Is this toilet slogan correct usage of the English language? Symbol used to indicate indivisibility What if a revenant (monster) gains fire resistance? Is aluminum electrical wire used on aircraft? Closed-form expression for certain product Strong empirical falsification of quantum mechanics based on vacuum energy density How should I respond when I lied about my education and the company finds out through background check? Pre-mixing cryogenic fuels and using only one fuel tank How do you respond to a colleague from another team when they're wrongly expecting that you'll help them? How can I block email signup overlays or javascript popups in Safari? How to implement a feedback to keep the DC gain at zero for this conceptual passive filter? Count the occurrence of each unique word in the file Why electric field inside a cavity of a non-conducting sphere not zero? If infinitesimal transformations commute why dont ...
                    Read more

                    Category:Fedor von Bock Media in category "Fedor von Bock"Navigation menuUpload mediaISNI: 0000 0000 5511 3417VIAF ID: 24712551GND ID: 119294796Library of Congress authority ID: n96068363BnF ID: 12534305fSUDOC authorities ID: 034604189Open Library ID: OL338253ANKCR AUT ID: jn19990000869National Library of Israel ID: 000514068National Thesaurus for Author Names ID: 341574317ReasonatorScholiaStatistics

                    Image
                    1880 births1945 deathsFedor (given name)Recipients of the Pour le Mérite (military class)Recipients of the Military Merit Cross (Austria-Hungary)Knight's Cross of the Iron Cross recipientsRecipients of the Order of Michael the BraveRecipients of the Order of the Crown (Prussia)Recipients of the Order of the Crown (Württemberg)Recipients of the House Order of HohenzollernRecipients of the Order of the Zähringer LionRecipients of the Hanseatic CrossRecipients of the House Order of the Wendish CrownRecipients of the Order of the Iron CrownGrand Master of the Order of Military Merit (Bulgaria)Recipients of the Order of the Yugoslav CrownRecipients of the Order of Merit of the Republic of HungaryRecipients of the Cross of HonorKnights Grand Cross of the Order of the Crown of ItalyBock (surname)19th-century men of Germany20th-century men of GermanyField Marshals of the Heer (Wehrmacht)Generals of the ReichswehrHeer Knight's Cross of the Iron Cross recipientsMen of Germany by na...
                    Read more

                    Kiel Indholdsfortegnelse Historie | Transport og færgeforbindelser | Sejlsport og anden sport | Kultur | Kendte personer fra Kiel | Noter | Litteratur | Eksterne henvisninger | Navigationsmenuwww.kiel.de54°19′31″N 10°8′26″Ø / 54.32528°N 10.14056°Ø / 54.32528; 10.14056Oberbürgermeister Dr. Ulf Kämpferwww.statistik-nord.deDen danske Stats StatistikKiels hjemmesiderrrWorldCat312794080n790547494030481-4

                    Image
                    DitmarskenFlensborgLauenburgKielLübeckNeumünsterNordfrislandØstholstenPinnebergPlönRendsborg-EgernførdeSlesvig-FlensborgSegebergSteinburgStormarnStuttgartMannheimKarlsruheFreiburg im BreisgauHeidelbergHeilbronnUlmPforzheimReutlingenBerlinBremenBremerhavenFrankfurt am MainWiesbadenKasselDarmstadtOffenbach am MainHannoverBraunschweigOsnabrückOldenburgWolfsburgGöttingenHildesheimSalzgitterMainzLudwigshafen am RheinKoblenzTrierDresdenLeipzigChemnitzKielLübeckKaunasKlaipėdaPärnuRigaTallinnTartuViljandiPolotskElblagGdanskKrakówStargard SzczecinskiSzczecinTorunWroclawBerwick-upon-TweedBostonGreat YarmouthKing's LynnKingston upon HullIpswichLeithLondonNewcastle upon TyneYork Byer i Slesvig-HolstenKielHanse NordtysklandhovedstadendelstatenSlesvig-HolstenTysklandsKielerfjordenØstersøenLangelandÆrøHamborgEjderenVesterhavetdansktyskslavisk1865Kielerkanalen1918novemberrevolutionenoprør blandt matrosernekejserlige marineW...
                    Read more