Active Forums

PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 21 Jan 2020 10:11 AM by  Paul Fijma
Find Missing Index
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages

Paul Fijma



New Member


Posts:23
New Member


--
21 Jan 2020 10:09 AM
    SQL Scripts: How To Find Missing Indexes (Posted on June 5, 2018 by Eric Cobb)

    One of the really cool things that SQL Server does is keep up with index statistics behind the scenes. It knows how an index has been used, how often it is used, or if it is even being used at all. But SQL Server doesn’t just monitor the indexes that you currently have, it even keeps up with statistics for indexes that it wishes you had!
    What Are Missing Indexes?
    When SQL Server is processing a query, it will sometimes make a suggestion for an index that it believes will help that query run faster. These are known as Missing Indexes, or as I like to refer to them, Missing Index Suggestions. The reason that I stress “suggestions” is that while SQL Server is very good at determining when an index is needed, it sometimes isn’t so good at recommending what that index should be.

    http://www.sqlnuggets.com...ind-missing-indexes/


    Paul Fijma



    New Member


    Posts:23
    New Member


    --
    21 Jan 2020 10:11 AM
    additional: http://www.sqlnuggets.com...oss-server-restarts/
    and https://github.com/ericcobb/SQL-Server-Metrics-Pack
    You are not authorized to post a reply.