Several questions about sp_BlitzIndex

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP












2















When sp_BlitzIndex does index suggestions, the question in my head is as below:



Yes the suggested index would bring a lot of speed benefit when doing select statements. But there are also another costs for these indexes which are delete, insert, update queries



Do sp_BlitzIndex script take into consideration delete, insert, update costs as well? or only it does evaluate how much speed benefit would come with select statements?



Moreover, how can i list bad indexes via sp_BlitzIndex? and how are they determined to be bad?



Thank you very much for answers










share|improve this question




























    2















    When sp_BlitzIndex does index suggestions, the question in my head is as below:



    Yes the suggested index would bring a lot of speed benefit when doing select statements. But there are also another costs for these indexes which are delete, insert, update queries



    Do sp_BlitzIndex script take into consideration delete, insert, update costs as well? or only it does evaluate how much speed benefit would come with select statements?



    Moreover, how can i list bad indexes via sp_BlitzIndex? and how are they determined to be bad?



    Thank you very much for answers










    share|improve this question


























      2












      2








      2








      When sp_BlitzIndex does index suggestions, the question in my head is as below:



      Yes the suggested index would bring a lot of speed benefit when doing select statements. But there are also another costs for these indexes which are delete, insert, update queries



      Do sp_BlitzIndex script take into consideration delete, insert, update costs as well? or only it does evaluate how much speed benefit would come with select statements?



      Moreover, how can i list bad indexes via sp_BlitzIndex? and how are they determined to be bad?



      Thank you very much for answers










      share|improve this question
















      When sp_BlitzIndex does index suggestions, the question in my head is as below:



      Yes the suggested index would bring a lot of speed benefit when doing select statements. But there are also another costs for these indexes which are delete, insert, update queries



      Do sp_BlitzIndex script take into consideration delete, insert, update costs as well? or only it does evaluate how much speed benefit would come with select statements?



      Moreover, how can i list bad indexes via sp_BlitzIndex? and how are they determined to be bad?



      Thank you very much for answers







      sql-server sql-server-2017 sp-blitzindex






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 3 at 12:45









      Brent Ozar

      34k19101229




      34k19101229










      asked Jan 3 at 12:01









      MonsterMMORPGMonsterMMORPG

      276215




      276215




















          1 Answer
          1






          active

          oldest

          votes


















          6














          and welcome to Stack Exchange. Going forward, try to break questions out individually. Here's how to write a great question.




          Do sp_blitz script take into consideration delete, insert, update costs as well?




          sp_BlitzIndex has several sections based on SQL Server's diagnostic management views.



          • The missing indexes are based on sys.dm_db_missing_index_details, which don't take into account delete/update/inserts.

          • The existing indexes list is based on sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats, which do take into account deletes/updates/inserts.


          Moreover, how can i list bad indexes via sp_blitz? and how are they determined to be bad?




          sp_BlitzIndex doesn't call indexes bad. It treats indexes a lot like human behaviors - for example, hoarding isn't necessarily bad in small amounts, or agoraphobia, or kleptomania, or being a furry. All kinds of behaviors are okay in small doses. It's up to you, not the script, to determine if an index is bad.






          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%2f226249%2fseveral-questions-about-sp-blitzindex%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









            6














            and welcome to Stack Exchange. Going forward, try to break questions out individually. Here's how to write a great question.




            Do sp_blitz script take into consideration delete, insert, update costs as well?




            sp_BlitzIndex has several sections based on SQL Server's diagnostic management views.



            • The missing indexes are based on sys.dm_db_missing_index_details, which don't take into account delete/update/inserts.

            • The existing indexes list is based on sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats, which do take into account deletes/updates/inserts.


            Moreover, how can i list bad indexes via sp_blitz? and how are they determined to be bad?




            sp_BlitzIndex doesn't call indexes bad. It treats indexes a lot like human behaviors - for example, hoarding isn't necessarily bad in small amounts, or agoraphobia, or kleptomania, or being a furry. All kinds of behaviors are okay in small doses. It's up to you, not the script, to determine if an index is bad.






            share|improve this answer



























              6














              and welcome to Stack Exchange. Going forward, try to break questions out individually. Here's how to write a great question.




              Do sp_blitz script take into consideration delete, insert, update costs as well?




              sp_BlitzIndex has several sections based on SQL Server's diagnostic management views.



              • The missing indexes are based on sys.dm_db_missing_index_details, which don't take into account delete/update/inserts.

              • The existing indexes list is based on sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats, which do take into account deletes/updates/inserts.


              Moreover, how can i list bad indexes via sp_blitz? and how are they determined to be bad?




              sp_BlitzIndex doesn't call indexes bad. It treats indexes a lot like human behaviors - for example, hoarding isn't necessarily bad in small amounts, or agoraphobia, or kleptomania, or being a furry. All kinds of behaviors are okay in small doses. It's up to you, not the script, to determine if an index is bad.






              share|improve this answer

























                6












                6








                6







                and welcome to Stack Exchange. Going forward, try to break questions out individually. Here's how to write a great question.




                Do sp_blitz script take into consideration delete, insert, update costs as well?




                sp_BlitzIndex has several sections based on SQL Server's diagnostic management views.



                • The missing indexes are based on sys.dm_db_missing_index_details, which don't take into account delete/update/inserts.

                • The existing indexes list is based on sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats, which do take into account deletes/updates/inserts.


                Moreover, how can i list bad indexes via sp_blitz? and how are they determined to be bad?




                sp_BlitzIndex doesn't call indexes bad. It treats indexes a lot like human behaviors - for example, hoarding isn't necessarily bad in small amounts, or agoraphobia, or kleptomania, or being a furry. All kinds of behaviors are okay in small doses. It's up to you, not the script, to determine if an index is bad.






                share|improve this answer













                and welcome to Stack Exchange. Going forward, try to break questions out individually. Here's how to write a great question.




                Do sp_blitz script take into consideration delete, insert, update costs as well?




                sp_BlitzIndex has several sections based on SQL Server's diagnostic management views.



                • The missing indexes are based on sys.dm_db_missing_index_details, which don't take into account delete/update/inserts.

                • The existing indexes list is based on sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats, which do take into account deletes/updates/inserts.


                Moreover, how can i list bad indexes via sp_blitz? and how are they determined to be bad?




                sp_BlitzIndex doesn't call indexes bad. It treats indexes a lot like human behaviors - for example, hoarding isn't necessarily bad in small amounts, or agoraphobia, or kleptomania, or being a furry. All kinds of behaviors are okay in small doses. It's up to you, not the script, to determine if an index is bad.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Jan 3 at 12:06









                Brent OzarBrent Ozar

                34k19101229




                34k19101229



























                    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%2f226249%2fseveral-questions-about-sp-blitzindex%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

                    How to check contact read email or not when send email to Individual?

                    Displaying single band from multi-band raster using QGIS

                    How many registers does an x86_64 CPU actually have?