ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
HIDDEN COSTS
 of Outdated Database Performance Strategies
Silos of Non-Communication




There are FOUR problems that result…
1. Crisis Mode Problem Solving




            Too much finger pointing
            Everyone has their own tools
            No sharing of solutions
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
3. Focus on the Wrong Thing




DBA Server Statistics                  Developer Test Runs




        Who is Focused on the End User?
4. DBAs Unable to See
 Performance on Virtual Servers



                 Database

             Operating System

            Virtual Machine (VM)

Invisible                          Frequent
 to DBA
               Physical Host
                                   Changes

              Storage System
The Solution



          Simplicity for non-DBA experts
              One solution for all silos
      Visibility to the virtualized datacenter
Focus on application performance, not server stats
Unless you can do all 3, you can’t
Isolate the problem and solution




         Measure Time
           Impact
How It’s Done

Identify the Exact Problem
                                            Wait Events

                             Database
  Query
 Request

 Query
Response
                               Bottleneck
Pictures a Manager
        Can Understand




                             Response Time


Query


                                Bottleneck
                                  (Wait Event
                                 or Wait Type)
Virtualization Visibility for DBAs



Application Response
     Time Layer

  Database Layer


   VM O/S Layer


 Physical Host Layer


   Storage Layer
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
Go From Reactive to Proactive

Focus on end user
Make the entire team work smarter
Achieve IT enlightenment
Value Numbers




            Fastest Growing Database
              Performance Software
                    Company




Instances                              Clicks to Find
                                          Problem




               Minutes to See Value
Reputation with largest
companies worldwide
Our Customers Love Ignite


• Quote
• Quote
• Quote
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

More Related Content

Confio presentation

  • 1. HIDDEN COSTS of Outdated Database Performance Strategies
  • 2. Silos of Non-Communication There are FOUR problems that result…
  • 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
  • 16. Our Customers Love Ignite • Quote • Quote • Quote
  • 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