SQL Server Performance

TSQL Improvements during upgradtion to SQL2005 from SQL2000

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by Aston, Jun 17, 2008.

  1. Aston New Member

    Hi Experts,
    We are upgrading to SQL2005 from SQL2000. So I need to review the TSQL of existing procs to incorprating new features of SQL2005 for performance improvement.
    Please let me know the tutorials or any other help related to this.
  2. satya Moderator

    Have you gone through UPGRADE ADVISOR tool on this database?
    It is better to run thru this tool in order to get any reference on the issues that might cropup and differences between 2000 & 2005 versions.
    Best option is to reindex all the tables when you have upgraded the database in order to store the best plan in the cache and optimizer will be taking care of such performance aspect.
    Also review the content http://sqlserver-qa.net/blogs/tools/archive/2008/01/22/upgrade-blurg.aspx on this blog post.
  3. ghemant Moderator

Share This Page