Post reply

Table Index Tool

  • February 10, 2012 at 7:07 am

    #255523

    Is there "tools" available to evaluate your SQL table and recommend the correct table indexes?

  • February 10, 2012 at 7:11 am

    #1445536

    Hi

    I'd start with the Database Engine Tuning Advisor.

    SQL Server Management Studio -> Menu -> Database Engine Tuning Advisor.

    But review and refine the index recommendations, it often shows too many "missing" indexes with too many columns

    Greets

    Flo

  • February 10, 2012 at 7:53 am

    #1445576

    Ever heard of Performance Dashboard?

  • February 10, 2012 at 8:15 am

    #1445594

    Yes, but not used yet. As far as I know, the performance dashboard is more useful for production administration. I'm not sure if it will give you same detailed information like tuning advisor.

  • February 10, 2012 at 8:17 am

    #1445600

    Try this "free tool". 😉

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/27/digging-into-the-sql-plan-cache-finding-missing-indexes.aspx

    -- Gianluca Sartori

  • February 10, 2012 at 8:17 am

    #1445601

    Thank you

  • February 10, 2012 at 8:24 am

    #1445607

    ok - this looks cool!!! Especially this part --- http://sqlfool.com/2009/03/find-missing-indexes/

    It isn't even anything I need to install. It is just code that "informs" me - doesn't change anything. Which is good.... (if I am understanding it correctly)

  • February 10, 2012 at 12:32 pm

    #1445746

    Yes, querying the missing index information from the cache is a useful starting point, but it's just that. Unfortunately, there are no good tools for auto-tuning databases. The Tuning Advisor can help some, but it's frequently wrong. Missing index information can be wrong too. No, the bad news is, the best way to tune a database is through knowledge and hard work. I'd suggest starting with Gail Shaw's excellent article.[/url]

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 10, 2012 at 12:44 pm

    #1445752

    mjbkm (2/10/2012)

    ok - this looks cool!!! Especially this part --- http://sqlfool.com/2009/03/find-missing-indexes/

    It isn't even anything I need to install. It is just code that "informs" me - doesn't change anything. Which is good.... (if I am understanding it correctly)

    It's a suggestion. It's a good place to start, a terrible place to finish.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 9 posts - 1 through 8 (of 8 total)

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