Post reply

Missing indexes in current requests

  • September 25, 2014 at 12:52 pm

    #293712

    Comments posted to this topic are about the item Missing indexes in current requests

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • October 7, 2014 at 9:21 am

    #1750628

    Great script, I liked it. Even though it returns results only for queries that being executed at the current moment, it's good.

    From Text field I can find out the text of stored procedure. And also query_plan is helpful. I saved XML with .sqlplan extension, reopened it again in SSMS, and it showed plan in graphics, along with the "green" hint for a missing index text.

  • November 4, 2014 at 9:26 am

    #1756576

    SQL Guy 1 (10/7/2014)

    Great script, I liked it. Even though it returns results only for queries that being executed at the current moment, it's good.

    From Text field I can find out the text of stored procedure. And also query_plan is helpful. I saved XML with .sqlplan extension, reopened it again in SSMS, and it showed plan in graphics, along with the "green" hint for a missing index text.

    Thank you! Queries that takes a long time to execute are likely to have a missing index and will get cought by this script. It's also very useful when someone complains about Performance right now, you just execute the script to see if there are a Query running right now that have a missing index.

    Before you create the index, make sure there is not an index that you can improve by adding some columns.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • March 14, 2016 at 7:12 am

    #1864900

    Thanks for the script.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply