SQL Server Performance

performance tuning

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by bond_isamashi, Apr 17, 2009.

  1. bond_isamashi New Member

    Does the performance tuning wizard really helps to
    improve the access time of database and user experience?
    is there any case study to confirm the above thing.

  2. Luis Martin Moderator

    Welcome to the forum.
    Yes it help.
    There is no case study (as far I know), but you can find some articles.
    Here is one of them:
    http://www.sql-server-performance.com/tips/index_tuning_wizard_p1.aspx
    This article was written for sql 2000. The only difference between 2000 and 2005 or 2008 is the name of the tool.
    In 2000 is Index tuning wizard. In 2005 is DTA.
  3. bond_isamashi New Member

    Thanks a lot Luis Martin,it really heled me lot.

Share This Page