Page History

...

But if this was an application that had a lot of different SQL and the SQL load was well distributed across the system then we'd have a case for adding more hardware to the system. Making the decision to add more hardware can be a difficult decision because in general the information to make the decision is unknown, unclear or just plain confusing, but SQL Query Tuner DB Optimizer makes it easy and clear, which can save weeks and months of wasteful meetings and debates. For example:

...

• With the load chart we can quickly and easily identify the bottlenecks in the database, take corrective actions, and see the results. In part 1, we had an application problem, in part 2 we had 3 database configuration issues and in part 3 we had a hardware sizing issue. In all 3 instances SQL Query Tuner provides a clear and easy presentation of the data and issues making solutions clear.