SQL Server Performance

Tuning with Yukon

Discussion in 'SQL Server 2005 General DBA Questions' started by Luis Martin, Apr 16, 2004.

  1. Luis Martin Moderator

    Just for fun and learn, I install Yukon Beta1 tools in new work station partition.
    I have a lot of trace from my customers. I pick one customer trace and one user, about 100 rows.
    I run Index Tunig Wizard SQL 2000 SP3 and finish with 0 recomendation. I print all informs that wizard give, most important indexs used.

    After that I run Index Tunig Wizard Yukon, and finish with 2 recomendations and 72% improve.
    I repeat the two steps twice.
    I analize recommendations, compare with availables indexs, see execution plan for some query and sound razonable to me to apply those new index, so I did it.

    I run ITW 2000 again, same trace, and finish with 0 recomendation, but now those new indexs are used againts others.
    I run the application and run faster than before.

    So I get 5 users more with differents traces, and in 4 I get better performance with new indexs.
    Is important to explain the following: ITW 2000 give me good results and works fine, in fact I have no complaint from my customers.

    Is not my idea to implementate what I find until final release, is just and experiment.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  2. gaurav_bindlish New Member

    Yeah I beleive the hiuge response to first version in SQL 2K has made Microsoft make huge improvements in the same.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  3. satya Moderator

    Just a thought, between the execution of ITWs have you tried to refresh the SQL services which may give you the exact results.

    Though its on BETA and many spurious and astonishing results can be expected.
    The ITW is enhanced by leaps and bound.
    The hypothetical indexes are created by ITW during the analysis process it id doing.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. Luis Martin Moderator

    Let me see if I follow you.
    The experiment was:
    Box server with SQL 2000 SP3 not Yukon.
    One WS with SQL 2000 SP3 tools and other WS with Yukon tools.
    After Yukon ITW finish I create a file with recommendations, read in Yukon SQL Analyzer, change some index name (just to indentify) and apply recomendations. No hinds, only Indexs.

    And I don´t refresh SQL 2000 Services.
    Should I refresh between ITW in any case?




    Luis Martin
    Moderator
    SQL-Server-Performance.com

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  5. satya Moderator

    Yes, I mean to say refresh the SQL services in between the ITW executions.
    As this is for test purpose and to get the optimum results.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. Luis Martin Moderator

    Thanks, I'll do that.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  7. satya Moderator

    I feel we need some more time to take it granted on few assumptions about SQL 2K5 & ITW working fashion.

    [8D] more the merrier .... on the terms of testing [8D]

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. Luis Martin Moderator

    Yes, agree with you, but you know, curiosity kill the cat[<img src='/community/emoticons/emotion-2.gif' alt=':D' />].<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br />The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  9. satya Moderator

    BTW where is the cat.... I can see your curiosity [8D]

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page