SQL Server Performance

index tuning stored procedures

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by dmaddhali, Dec 20, 2005.

  1. dmaddhali New Member

    Hello All
    I have a small query . Can we use any stored procedures / queries which can do the task of Index tuning wizard. What I mean is ; Is there any programatical way to do the tasks which index tuning wizard is doing ?
    dmaddhali, Dec 20, 2005
    #2

  2. Luis Martin Moderator

    Open the query in SQL Server Managment Studio, point the query in your database, in tools you will find Database Engine Tuning Advisor. This tools work like Index Tuning Wizard 2000.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
    [/size=1]

    All postings are provided “AS IS” with no warranties for accuracy.[/size=1]



    Luis Martin, Dec 20, 2005
    #2

  3. satya Moderator

    satya, Dec 21, 2005
    #2

Share This Page