SQL Server Performance

How to test Index Tuning Changes before implementing in Production?

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

  1. ZLA New Member

    I am working with SQL Profiler and the Index Tuning Wizard in order to improve the database performance for my client's web site. Before I implement any index recommendations, I would like to measure the performance improvement. My best guess at the moment is to start from a fresh production copy of the database and run some standard set of SQL statements against it before and after any index changes. If I have the profiler running during both tests, I can compare the two runs.
    Are there other, perhaps better, ways to do this? Thanks in advance.
  2. Luis Martin Moderator

    Kindly don't duplicate post.
    I've lock this one, because belong to 2000 (ITW)

Share This Page