|DB Optimizer XE2 - Praise|
Running our company monthly invoices were taking upwards of three hours to run and sometimes the SQL server would stop processing the invoices. We needed to find out what was causing the slow down as fast as possible and fix it. DB Optimizer allowed us to see that the indexes were not optimized, memory was being squeezed and the I/O subsystem was not the best fit. This allowed our team to tackle the three major issues all at the same time without going down a wrong path. Without DB Optimizer we would have had to use numerous tools and then correlate the data to find what were the issues causing the slowdown which would have taken many man-hours to do. It is nice to have all these abilities in one package to save us time and money
The golden rule with SQL is quality in equals quality out, so there's nothing worse than sending poor SQL code to production and having it negatively affect database or application performance. When using DB Optimizer, we've found that it helps us pinpoint data-intensive or frequently executed queries and optimize any problematic statements, thus improving the overall performance of our application
It has already helped me tremendously in addressing some of our DB2 performance issues. It also provides a great platform for working with the developers to discuss processing issues that the DBAs see in a given processing window.