Post reply

Index Tuning

  • March 15, 2011 at 10:47 am

    #236403

    Hi All,

    one of my server is still using SQL 2k so can u all provide me some help regarding index tuning in

    SQL 2k because i don't know much abt it in SQL 2k

    I will be very thankful .

    Regards,

    Ajit

  • March 15, 2011 at 11:32 am

    #1299021

    Query tuning is largely the same as in more recent versions as regards query execution plans, etc.

    If you are unfamiliar with the SQL 2000 tuning wizard, I wrote a walk through article about it here: http://www.sqlwatchmen.com/articles/indexes.aspx. It just covers the basics and using the 2000 version of the tools like Profiler, etc.

    Jim

    Jim Murphy
    http://www.sqlwatchmen.com
    @SQLMurph

  • March 17, 2011 at 1:17 pm

    #1300180

    Thanks Jim

    I am looking for any approach that using DBCC showcontig properly.

    Thanks In advance

  • March 17, 2011 at 3:17 pm

    #1300256

    Showcontig has nothing to do with index tuning. Index maintenance, yes, but not index tuning.

    Tuning refers to creating and altering indexes to support the workload. Maintenance is rebuilding as necessary and that's what showcontig helps with.

    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 4 posts - 1 through 3 (of 3 total)

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