Run our Query Optimizer tool initially for a short period of time. This data collection can have some impact on the system so be careful with the parameters. Just run it long enough to get some data to start with. Once improvements are made, you will be able to run it longer the next time.

If SQL and queries are running excessively in your environment, there likely are opportunities to improve performance through some database and SQL tuning. Building of new indexes though is only one of the ways to improve SQL performance. There are many others. Use our online Resource Center and see many other opportunities that exist for improving the performance of this type of processing.