Confio Shrinks Database Wait-Time
By Pedro Hernandez
October 4, 2006
There's nothing more frustrating than an application that hangs a virtual "please wait" sign while you're waiting for a response. For corporations, this can add up to lost productivity. Worse, it can lead to lost business if customers turn their backs on sluggish account services or Web ordering systems.
The culprits? Databases and Java apps.
Boulder, Colorado-based Confio is confident that its software can banish wait-time, better known as that sometimes interminable lag endured by users as database queries wend their way through to their conclusions. For databases, however, it can be the symptom of hardware or configuration problems.
But you're not a DBA, you many be thinking. What does that have to do with you? Plenty, if you care at all about server performance.
Released this summer, Confio released Ignite for Oracle and Ignite for Java — software that takes a different approach to measuring transactions.
Instead of relying on the time it takes to complete a transaction and report on the possible causes, Ignite zeroes in on bottlenecks by analyzing each SQL statement and observing over 900 Oracle wait events. For J2EE application servers, Ingite exposes the Java call stack, helping to identify which calls and methods are interacting with the database in a less-than-efficient manner.
This insight is gleaned by an agentless design that watches for the telltale signs that requests aren't being fulfilled quite as fast as they should. The company claims that the performance penalty is negligible, adding a penalty of less than 1 percent under supported versions of Oracle (8, 8i, 9i, and 10g). A repository server collects data and processes the data and a software client for Windows (XP, Server 2003 with Oracle SQL*Plus) is used to view and compile reports.
Collectively, the two offerings provide an end-to-end survey of where the works are getting gummed up. For IT personnel, this cuts down having to hunting down the problem and helps them quickly identify which role, be it a DBA or a sysadmin, can bring problems to a speedy resolution.
Speaking of DBAs, they can use Ignite to help pinpoint configuration shortcomings or gauge how hard applications (or which of its components) are hitting the database and tune it accordingly. Additionally, they can chart performance over days, weeks and months to judge the impact of tweaks over the long term or to account for seasonality or other time-based factors, for instance.
Alerting functions mirror those of popular network monitoring and management tools. Admins can opt for alerts via cell phone, email, and pagers, as well as via SNMP events that are compatible with popular monitoring suites such as Tivoli and HP Openview.
Ignite for Oracle and Ignite for Java are available now. Confio offers a free trial downloads here.