Spectacular Results
Impact, Now
Here are some samples of the results that Hotsos customers have achieved. We think they're spectacular. Judge for yourself:
- Icelandic financial institution
Reduced key query in a daily batch job from 6½ hours to less than 11 seconds with first use of Hotsos Profiler.
...from 6½ hours to less than 11 seconds.
- City of Chandler, Arizona
Using Hotsos Profiler, spent less than one minute of analysis time to reduce the run-time of a 3-hour job to 43 seconds. The performance problem had evaded other tools.
...from 3 hours to 43 seconds.
- Fortune 100 manufacturer
DBA left our class on Thursday and by Friday afternoon had reduced the response time of a query from 44 minutes to 0.41 seconds. Student claimed that Hotsos education "completely changed his view of tuning the database."
...from 44 minutes to 0.41 seconds.
- Mark Strickland, independent consultant
Using the Hotsos diagnostic method, consultant fixed an I/O configuration problem that reduced the run time of a conversion process that would have taken 23 days to just 5 hours.
...from 23 days to 5 hours.
- Resort management company
In ½-day consulting visit, remedy identified in first run of the Hotsos Profiler more than doubled Oracle Payroll throughput after client spent 3+ months and over $40,000 (USD) on conventional "tuning".
...doubled Oracle Payroll throughput.
- Convergys
Hotsos student identified a 2-minute fix that resulted in a system CPU capacity savings of 12 percent on the database server. While the optimized action was not identified by the user community as a response-time issue and the response time per execution was a little over one second, the frequency with which this query was run produced so much work for the database server that it consistently occupied a CPU.
...12% CPU savings.
- Wyndham Hotels
In a ½-day consulting visit, Hotsos consultant used the Hotsos Profiler on a system that had been thoroughly analyzed with Precise i3, to reduce total workload by over 100 hours of processing time per day.
...100-hour daily CPU load reduction.
- Fortune 100 software company
In an afternoon on-site seminar, Hotsos consultant reduced total workload on a new server by over 50 percent. Inefficiencies that were corrected in an afternoon had motivated the recent purchase of a new $25,000 (USD) hardware upgrade.
...50% system-wide workload reduction.
- City of Ottawa
DBA left our classroom on Thursday and by Friday afternoon had reduced run times for two separate 1-hour batch jobs to 6 minutes each. Prior to the course, the company had invested over a month of labor into tuning the jobs.
...from 1 hour to 6 minutes.
- Fortune 100 manufacturer
-
Novice performance analyst using Hotsos Profiler reduced run time of Oracle Applications month-end close process by 90 percent within first six weeks after training.
...90% reduction in month-end close processing time.
