This document discusses the problems that result from outdated database performance strategies and siloed teams. It identifies four key problems: 1) crisis mode problem solving with finger pointing between teams, 2) developers inability to see code in production environments, 3) focusing on the wrong metrics like server stats instead of application performance, and 4) DBAs inability to see performance on virtual servers. It then introduces Ignite as a solution that provides visibility across teams and environments, focuses on application performance, and can identify bottlenecks without agents or load. It claims Ignite is the fastest growing database performance software company and provides customer testimonials praising its value and ease of use.
3. 1. Crisis Mode Problem Solving
Too much finger pointing
Everyone has their own tools
No sharing of solutions
4. 2. Developers Can’t See Code In Production
Business
User Demand
DEV DBA
Typical Situations
• Developer has no visibility to Staging or Production
• DBA has no way to communicate causes to Development
• Time-to-market delays
5. 3. Focus on the Wrong Thing
DBA Server Statistics Developer Test Runs
Who is Focused on the End User?
6. 4. DBAs Unable to See
Performance on Virtual Servers
Database
Operating System
Virtual Machine (VM)
Invisible Frequent
to DBA
Physical Host
Changes
Storage System
7. The Solution
Simplicity for non-DBA experts
One solution for all silos
Visibility to the virtualized datacenter
Focus on application performance, not server stats
8. Unless you can do all 3, you can’t
Isolate the problem and solution
Measure Time
Impact
9. How It’s Done
Identify the Exact Problem
Wait Events
Database
Query
Request
Query
Response
Bottleneck
10. Pictures a Manager
Can Understand
Response Time
Query
Bottleneck
(Wait Event
or Wait Type)
11. Virtualization Visibility for DBAs
Application Response
Time Layer
Database Layer
VM O/S Layer
Physical Host Layer
Storage Layer
12. No Agent, No Load:
Ignite Agentless Architecture
Web Browsers
Ignite Server Monitored Servers
SQL Server
2000, ‘05, ‘08, ‘12 SQL
SQL
SQL
Ignite
DBA
Oracle
8i, 9i, 10g, 11g SQL
SQL
Oracle
IT Manager DB2
8.1 FP13 and up SQL
SQL
Repository DB2
Database
Oracle or SQL Server
Sybase
12.5.03 and up SQL
SQL
Sybase
Dev/Test
13. Go From Reactive to Proactive
Focus on end user
Make the entire team work smarter
Achieve IT enlightenment
14. Value Numbers
Fastest Growing Database
Performance Software
Company
Instances Clicks to Find
Problem
Minutes to See Value
17. Thank you!
www.Confio.com
FREE TRIAL
Free Unlimited Trial on Unlimited Servers
Download and Install in Minutes
Free Expert DBA Consultation
Written Performance and ROI Results