SQL Server Performance Tuning

We’ve gotten so good at performance tuning that we give a guaranteed 30% overall performance improvement or you get your money back*. Our performance tuning process is an iterative cycle consisting of these steps:

  1. A first baseline is taken.
  2. Major bottlenecks are identified and fixed.
  3. A second baseline is taken and the impact of the change is analyzed by comparing the two measurements

instaDBA SQL Server Performance Tuning Method

*The 30% performance improvement guarantee can only be given after a first baseline has been taken of the server. The performance improvement is measured by looking at the total execution time of all queries running against the server during the monitoring session.