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

Why has the US not been more assertive in confronting Russia in recent years?

Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis

If/When UK leaves the EU, can a future goverment conduct a referendum to join the EU?

How do scammers retract money, while you can’t?

Several mode to write the symbol of a vector

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

How to make a variable always equal to the result of some calculations?

Is there a way to save my career from absolute disaster?

How did people program for Consoles with multiple CPUs?

What is ( CFMCC ) on ILS approach chart?

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

In excess I'm lethal

What does "Its cash flow is deeply negative" mean?

Limits on contract work without pre-agreed price/contract (UK)

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

Why did we only see the N-1 starfighters in one film?

Why am I allowed to create multiple unique pointers from a single object?

multiple labels for a single equation

Preparing Indesign booklet with .psd graphics for print

How fast would a person need to move to trick the eye?

Is it professional to write unrelated content in an almost-empty email?

I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin

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



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

                    कुँवर स्रोत दिक्चालन सूची"कुँवर""राणा कुँवरके वंशावली"

                    Image
                    पुष्टि की ज़रूरत वाले "सम्बंधित जाति समूह" क्षत्रियक्षेत्रीकर्णालीक्षेत्रीनेपाली भाषामेंकाजीबिष्टपाण्डेबस्नेतथापावत्सपृथ्वीनारायण शाहकेबलभद्र कुंवरभीमसेन थापाकेजंगबहादुर राणाराणा कुँवर/कँवर (गोरखाली) उपर: रामकृष्ण कुँवर बीच:बलभद्र कुंवर  · बालनरसिंह कुँवर तल:जंगबहादुर कुँवर राणा  · बमबहादुर कुँवर राणा कुल जनसंख्या ८२,१४९ नेपालमे (राणा कुँवरको छोडके) [1] [2] ख़ास आवास क्षेत्र   नेपाल भाषाएँ नेपाली भाषा धर्म हिन्दु धर्म और मष्टो धर्म अन्य सम्बंधित समूह पाँडे, थापा, बस्नेत, बिष्ट कुँवर वा कँवर नेपाली क्षत्रिय वर्णके क्षेत्री जातिके पारिवारिक नाम है। इस परिवारकी उत्पत्ति नेपालके कर्णाली प्रदेशमे अन्य क्षेत्री जातिके साथ हुआ था। कुँवरका अर्थ नेपाली भाषामें कुमार है। यिनका भारतीय राजपुत और मराठा राजाओं से कुछ वैवाहिक सम्बन्ध है। भारतमे पाएजानेवाले कुँवर अलग वंशजके है। कुँवर पाँच पुस्त्यौनी काजी परिवार मध्ये एक है। अन्य चार परिवार बिष्ट, पाण्डे, बस्नेत और थापा है। [3] इनके गोत्र वत्स गोत्र है। [4] रामकृष्ण कुँवर पृथ्वीनारायण शाहके सेनामे सरदार थे। बलभद्र कुंवर भीमसेन थापाके
                    Read more

                    Why is a white electrical wire connected to 2 black wires?How to wire a light fixture with 3 white wires in box?How should I wire a ceiling fan when there's only three wires in the box?Two white, two black, two ground, and red wire in ceiling box connected to switchWhy is there a white wire connected to multiple black wires in my light box?How to wire a light with two white wires and one black wireReplace light switch connected to a power outlet with dimmer - two black wires to one black and redHow to wire a light with multiple black/white/green wires from the ceiling?Ceiling box has 2 black and white wires but fan/ light only has 1 of eachWhy neutral wire connected to load wire?Switch with 2 black, 2 white, 2 ground and 1 red wire connected to ceiling light and a receptacle?

                    Image
                    Why one should not leave fingerprints on bulbs and plugs? New passport but visa is in old (lost) passport How to pronounce "I ♥ Huckabees"? Fastest way to pop N items from a large dict Why does energy conservation give me the wrong answer in this inelastic collision problem? Is there a place to find the pricing for things not mentioned in the PHB? (non-magical) Why did it take so long to abandon sail after steamships were demonstrated? Bach's Toccata and Fugue in D minor breaks the "no parallel octaves" rule? Problem with FindRoot Why do passenger jet manufacturers design their planes with stall prevention systems? Print a physical multiplication table "of which" is correct here? Why is the President allowed to veto a cancellation of emergency powers? Can I use USB data pins as power source How difficult is it to simply disable/disengage the MCAS on Boeing 737 Max 8 & 9 Aircraft? As a new Ubuntu desktop 18.04 LTS user,
                    Read more

                    चैत्य भूमि चित्र दीर्घा सन्दर्भ बाहरी कडियाँ दिक्चालन सूची"Chaitya Bhoomi""Chaitya Bhoomi: Statue of Equality in India""Dadar Chaitya Bhoomi: Statue of Equality in India""Ambedkar memorial: Centre okays transfer of Indu Mill land"चैत्यभमि

                    Image
                    मुम्बईबौद्ध तीर्थ स्थलभीमराव आंबेडकर को समर्पित स्मारक मुंबईदादरभारतीय संविधानडॉ भीमराव आंबेडकरबौद्ध धर्मदिल्लीमहापरिनिर्वाणमुंबईभदन्त आनन्द कौशल्यायनअरबी समुद्र चैत्यभूमि चैत्यभूमि मुंबई के दादर स्थित भारतीय संविधान के निर्माता भारतरत्न डॉ भीमराव आंबेडकर जी की समाधि स्थली और बौद्ध धर्म के लोगो का आस्था का केंद्र हैं। दादर के समुद्र तट पर चैत्य भूमि स्थित है। [1] [2] [3] [4] दिल्ली में अपने निवास में ६ दिसंबर १९५६ को आंबेडकर का महापरिनिर्वाण हुआ और उनका पार्थिव मुंबई में लाया गया, चैत्यभूमि में ७ दिसंबर १९५६ को भदन्त आनन्द कौशल्यायन ने आंबेडकर का बौद्ध परम्परा के अनुसार दाह संस्कार किया था। आंबेडकर का दाह संस्कार के पहले उन्हें साक्षी रख उनके १०,००,००० अनुयायिओं ने बौद्ध धम्म की दीक्षा ली और यह दीक्षा उन्हें भदन्त आनन्द कौशल्यायन ने दी थी। चित्र दीर्घा चैत्यभूमि स्तूप अशोकस्तंभ अशोकस्तंभ व प्रवेशद्वार (अंदर से) प्रवेशद्वार (अंदर से) चैत्यभूमि परिसर, आगे अशोकस्तंभ और अरबी समुद्र चैत्यभूम
                    Read more