Presentation Transcript

1. Presenter Name Title E-mail address

   Toad® DBA Suite for Oracle

2. DEVELOPMENT ADMINISTRATION Pressure Points on the Production Environment
3. Typical Time Breakdown for DBAs Does this look familiar? 20% 30% Source: James F. Koopmann An Expert’s Guide to Database Solutions: A DBA’s New Year Resolutions 50%
4. Database Administrators are Required to Assure:
5. Maintain databases quickly, easily and accurately Challenges “Enterprises must focus on formalizing database management through planning, standardization, and best practice adoption to improve operational efficiency and lower costs.” Noel Yuhanna, Forrester Research, Database Administration Challenges are Shifting “Automation (of administration) can typically save 15% or more in costs by way of reduced administration efforts. …relieving DBAs from trivial and routine tasks...” Noel Yuhanna, Forrester Research, Automating Database Administration Can Improve Efficiency and Lower Costs Assure Maintenance
6. Maintain databases quickly, easily and accurately The Solution Collectively views all managed databases enabling drill down to objects and execution of tasks all within the same window Simplifies routine tasks, including the administration of users, roles, object privileges, storage and more Automates the management and maintenance reporting of overall database health (including security vulnerabilities), schemas, index rebuilds, etc Improves consistency by enabling the execution of multiple scripts across multiple databases Assure Maintenance
7. Top down view of all managed databases Drill down to objects and perform tasks Assure Maintenance
8. Simplified user management without the scripts Helps safeguard against security issues Assure Maintenance
9. Check database health and security vulnerability Configurable per database Assure Maintenance
10. Assure Maintenance Automate and schedule the execution of repetitive tasks such as scripts, DDL generation, schema compares and reports
11. Diagnose and resolve problems before they impact production Challenges According to Forrester Research, 60-90 percent of database performance issues are SQL-related “Twenty-five percent of all database outages are related to human errors, mainly because of complexity in managing databases and infrastructure.” Noel Yuhanna, Forrester Research, Automating Database Administration Can Improve Efficiency and Lower Costs Poor database performance leads to slow end user response time or downtime that can directly impact your business’ bottom line Assure Performance 90% 60% Root of Database Performance Impact Source: Forrester Research
12. Diagnose and resolve problems before they impact production The Solution Diagnoses database performance bottlenecks through visual representation Pinpoints the source of long-running sessions and resource-intensive SQL Identifies problematic SQL directly from source code Provides expert advice and generates alternate SQL implementations Automates the SQL optimization process Assure Performance 90% 60% Root of Database Performance Impact Source: Forrester Research
13. Assure Performance Real-time database bottleneck detection with history Point-and-click drill-down and advice
14. Assure Performance Detailed diagnostics screens enable full visibility of problems, together with immediate resolution
15. Assure Performance Identify and fix database configuration problems with Oracle AWR and StatsPack browsing with advisories
16. Assure Performance Proactively scan, identify and classify problematic application SQL directly from the source code
17. Assure Performance Simple and automatic re-writing of SQL statements Optimized code is returned directly to the Toad Editor
18. Assure Performance Analyze what indexes could be created to improve performance of multiple SQL by using virtual indexing
19. Assess the impact of changes on production instances Challenges “Database change quickly can monopolize a DBA’s time. Preparing for change and implementing the proper tools, techniques, and procedures for database change management is one of the most important jobs undertaken by DBAs today.” Craig Mullins, data management strategist, researcher, and consultant Organizations consistently list “managing change” as one of the most significant challenges facing their IT departments. Whether planned or unplanned, changes can negatively impact database performance. Assure Change
20. Assess the impact of changes on production instances The Solution Evaluates the impact of database changes (upgrades, patches, new configurations, indexing) on SQL performance Preempt SQL performance regression due to indexing using what-if analysis Replays database workload in a test environment Enables deployment of schema and data model changes Assure Change
21. Assure Change Pre-empt performance degradation due to DB changes (migrations, configurations, indexing) by comparing SQL execution plans
22. Assure Change Evaluate performance impact of database changes in a test environment by replaying database workload, what-if analysis and customized load levels
23. Assure Change Compare schema changes and synchronize differences Snapshots and multiple targets for accuracy and flexibility
24. Assure Change Compare two data models and view differences Generate Alter script for deployment
25. Get it done quickly: utilize automation and best practices Challenges Too many manual processes Different tools Poor workflow Inconsistent views showing what’s happening which hampers correlation No direct resolution Assure Productivity
26. Get it done quickly: utilize automation and best practices The Solution Automation and scheduling for repetitive or time-consuming tasks Single suite of tools which interact providing smooth workflow Top down views of database environment with contextual drill-downs and advice Direct access to resolution tools like SQL tuning Assure Productivity
27. Assure Productivity Toad’s AppDesigner macros encapsulate common tasks Apps can be saved and shared to create a standardized workflow
28. Assure Productivity Automated SQL scanning and batch optimization Leaves DBAs with more time to perform other tasks
29. Assure Productivity Single view of all managed databases and schemas. Highly productive for task execution and object maintenance.
30. Introducing the Solution Toad® DBA Suite for Oracle… With the Toad DBA Suite for Oracle, you can improve operational efficiency to lower costs by formalizing database management through a systematic approach that assures maintenance, performance and change. Automate frequent and repetitive tasks for improved productivity and accuracy Decrease the total cost of ownership of Oracle by finding and fixing problems early, before problems impact production Meet Service Level Agreements (SLAs) by reducing the risk of slow transaction response time and downtime Employ a proactive approach to assessing the impact of changes, mitigating risk Assure Maintenance, Performance and Change
31. The Toad DBA Suite for Oracle includes: Toad for Oracle Xpert Editionwith DB Admin ModuleforPerformance Management and Maintenance (includes Quest SQL Optimizer for Oracle): simplify database administration through task automation and validate code to ensure the best-possible performance Toad DB Admin Module for Maintenance and Change Management:compare and synchronize database schema, objects and data and assess your risk for security vulnerabilities Spotlight on Oracle for Performance Management: visualize database components in real time and pinpoint performance problems quickly so you can easily eliminate bottlenecks And… Assure Maintenance, Performance and Change
32. The Toad DBA Suite for Oracle includes: Toad for Data Analysts for Maintenance:query, understand and report on data directly from almost any database or data source Benchmark Factory for Databases for Performance and Change Management (Oracle Edition):replay database workload to test performance under production-like conditions Toad Data Modeler for Change Management:visually create database structures and provide documentation or make changes to existing models Assure Maintenance, Performance and Change
33. Toad DBA Suite for Oracle Assure Maintenance, Performance and Change
34. Toad DBA Suite for Oracle Assure Maintenance, Performance and Change Business Impact Maintenance – better database visibility combined with task simplification and automated reporting gets the job done efficiently while minimizing the risk of inconsistencies impacting production Performance – accurate diagnosis and efficient resolution of performance problems due to inefficient code or inappropriate database configuration enables SLAs to be met Change– understanding the impact of changes together with on-time deployments reduces the risk of production downtime affecting the bottom line Productivity – reducing the DBAs workload through ease-of-use, better workflow, automation, consistency and accuracy enables the DBA to become much more pro-active and focus on longer-term tasks
35. www.toadworld.com Your One-Stop Resource for Education, Expertise and Collaboration In this free online community, you’ll find: Exclusive freeware downloads Direct access to experts like Steven Feuerstein, Bert Scalzo and Guy Harrison through their blogs and portals Insight-packed white papers and podcasts Toad tips and tricks videos Toad news and events Fun stuff like screen savers and ring tones Use Toad World 35
36. Toad DBA Suite for Oracle Questions? Thank you! Name E-mail address