New Version of SQL-GUY from Database-GUYS Inc

Database-GUYS Inc announced the general availability of Version 2.10 of SQL-GUY, their performance management tool for DB2 UDB UNIX that provides instantaneous real-time analysis of the most costly SQL statements in any workload mix.

Version 2.10 of SQL-GUY contains a number of valuable enhancements and is the first product on the market to evaluate, analyze, and track dynamic SQL statements and their individual costs.

Using dynamic SQL equalization, a complex mathematical SQL analysis process developed by Database-GUYS Inc., SQL-GUY V2 breaks down dynamic SQL, identifies unique statements, and assigns them an ID number. These dynamic statements are then analyzed, tracked, and execution costs are tabulated and aggregated. SQL-GUY V2 also provides for the real-time evaluation of application connections, providing detailed information such as the resources consumed by SQL statement execution and connections experiencing locking problems. Other new features include the ability to launch the DB2 Index Advisor, discover Automatic Summary Table opportunities, rapidly analyze locks held, lock waits, and lock contention, and the ability to predict when decision support queries will complete.

"Many packaged vendor solutions available today primarily use dynamic SQL, making it practically impossible to determine which statements are the most costly to your business," says Scott Hayes, president and founder of Database-GUYS Inc. "With SQL-GUY V2, you can immediately pinpoint the costliest SQL, static or dynamic, and make informed decisions on the changes needed to achieve the greatest performance improvement."

"User response to the new version has been extremely enthusiastic," says Mr. Hayes. "One client's e-Commerce Web site had slowed to an unacceptable crawl, with CPU utilization a steady 100% busy. In a matter of minutes, SQL-GUY V2 identified a low-cost but extremely high-volume statement (executed 10,000 times per minute) which was consuming almost 70% of the CPU. Once the problem statement was identified, adding a clustering index returned performance to exceptional levels and put the customer back in e-Business".

With a starting price as low as US $2,995/CPU and available multiple CPU and enterprise licensing discounts, SQL-GUY is poised to help IBM DB2 UDB UNIX customers achieve remarkable success. Interested parties should contact Database-GUYS Inc directly at 1-877-4DB-GUYS (toll-free in the US) or 1-716- 349-2450 (international) or visit the company's Web site at www.Database-GUYS.com to inquire about the tools or download a free trial. Database-GUYS Inc is located at 36 Walnut Hill Drive, Spencerport, NY 14559, and the fax numbers are 877-225-4452 (toll-free in the US) or 1-208-279-7041 (international).

Database-GUYS Inc is a privately held corporation providing performance management tools for DB2 UDB UNIX. In addition to SQL-GUY, the Database- GUYS team of performance management tools includes: Wise-GUY, which handles database monitoring and tuning; Pool-GUY, which monitors bufferpools and automates their tuning; Space-GUY, which helps assure database availability by monitoring tablespace utilization and performance; and Connection-MINER, which helps users understand how database resources are being used and by whom, providing a basis for calculating chargebacks and identifying problems.

Contact Database-GUYS Inc, Paula Hayes, Marketing Communications Director, 877-4DB-GUYS x7, PHayes@Database-GUYS.com.