Ignite for DBAs

Ignite gives DBAs a tool to improve their own depth and expertise, helping good DBAs become great ones. Have you ever suspected where a database problem originated, but been unable to prove it, while other groups pointed fingers at you? Or had a nagging issue that could not be resolved, only to find the culprit months later in a SQL statement that you never knew was running? Ignite exposes exactly what is taking place at a detailed level, giving the DBA the critical insight to understand and resolve the problem.

Unlike a trace, Ignite runs continuously so every session is always monitored. Showing detail unmatched in any monitoring tool, Ignite follows each SQL statement individually and identifies what specific request each session is waiting on. Ignite then ranks each problem based on its corresponding application wait time, which allows DBAs to focus on the issues important to the end users.

Wait-Time Analysis

Ignite measures performance using Wait-Time as the primary metric, so all activity is evaluated based on how it affects end user response time. In the past few years, leading books, courses and consultants have all pointed to Wait-Time analysis as the best practice for performance tuning. So why are so many DBAs still using old methods of performance monitoring? Possibly because traditional tools do not provide enough Wait-Time detail to be useful or the Wait-Time tools available are too heavy, complex and difficult to implement. How useful a performance tool is depends on the level of action a DBA can take based on the results. Confio's Igniter Suite is specifically designed to give DBAs instant, "actionable" answers about how to improve database performance.

Results in 30 Minutes

Ignite is installed by the DBA with no outside assistance required. DBAs get instant answers to relevant performance questions. Unlike other tools, no onsite integration or complex upgrades are required.

Agentless Architecture

Monitoring systems should not impose a load on the production system. Ignite's patented Agentless architecture allows it to continuously monitor all sessions while placing a load of less than 1% on the monitored systems. Since software is installed on a repository server, not on the production servers, Ignite is easy to introduce into production performance environments.

	Challenges Faced By DBAs Ignite Benefits Not enough detail to pinpoint real problems Detailed wait-event results at SQL statement level DBAs erroneously blamed for performance problems Irrefutable evidence of problem origination Complex installation and integration cost time and money Agentless install, running in 30 minutes, self installed Lack tools that expand DBA's knowledge and impact Empowers DBAs with demonstrable value Time wasted on changes that result in little impact Identify maximum performance impact before making changes Time spent translating process and results for non-DBAs Clear graphs and charts communicate results to all levels and departments

Being a DBA is tough job – with developers, vendors and management pointing fingers at the database, and few others in the organization having enough database knowledge to understand the challenges. Ignite gives DBAs a tool to excel and to demonstrate that excellence across the organization. It gives detailed information, but still presents it so that even non-DBAs can understand what is important. Results are never "dumbed down" to cover up the complexity of the database. From identifying the application code responsible for problems to creating simple reports that demonstrate how end user performance has improved, Ignite empowers DBAs to continue to do their best work and to prove it.