DPA Success Guide - Empower Developers

Version 2
    < Start   < BackNext >

    Empower Developersempower-developers.JPG

     

    Today's common complaint is no longer as much about a total failure of a component as it is about sluggishness. Unfortunately many development teams lack visibility when it comes to the relationship between SQL text and production DBMS performance. Ignite is a self-empowerment tool for developers, giving them the ability of being able to see the relationship between SQL text and query performance in both test and production.

     

    top-program-waits.jpg
    Tabs filter results based on programs, users, machines, and sessions



    ACTION:

    • Add developers as users in Ignite
    • Monitor production servers
      • Set appropriate levels of permission for development on production instances
      • Focus attention the top SQL problems and trends
    • Monitor QA and test servers
      • Focus on current view for active tests
      • Focus on historical trends when running automated tests
      • Use alarms and alerts to identify anomalies
      • Use historical baselines for contrast
    • Develop for test-ability
    < Start   < BackNext >