Sheryl Showed Us Big Money Hiding in Our SQL
Sheryl Larsen's SQL tuning webinar Find Lost Money in your SQL: Efficiently Finding and Fixing High Resource Consuming SQL, was sponsored by SoftBase and broadcast April 26 2012.
It was an incredibly informative and educational webinar, in which Sheryl showed us dozens of ways to reduce CPU usage. At the end of the presentation, Sheryl talked about a new CPU savings calculator she helped SoftBase develop. It estimates the amount of money your shop could save over a 5-year period by implementing multi-row FETCH in your existing applications manually or by using SoftBase’s Attach Facility MRF feature, which automatically retrofits your applications for multi-row FETCH. Simply enter your shop's CPU and number of DB2 applications, and we’ll generate a custom 5-year savings and ROI forecast, specific to your shop! It’s quick, easy and a little bit fun! Below is an example of what we’ll create for you. And yes, it's free.
In this scenario, the shop is licensed for 1200 MIPS, and has approximately 1,500 applications that could benefit from utilizing multi-row FETCH. Using Attach Facility, this shop saw not only an ROI of over 120% on their investment within 1 year, but saved over $3.9 million over a 5-year period!
Click here to build your own 5-year ROI and savings forecast!
Watch the Sheryl Larsen’s SQL Performance Webinar Replay
