sp_blitzCache results Memory grants












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










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










    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










      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






      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

                    GameSpot

                    日野市

                    Tu-95轟炸機