Reducing Costs and Improving Service with SmartDBA for Oracle

1
Reducing Costs and Improving Service with
SmartDBA for Oracle
Scott Sloan Business Unit Field
Manager Enterprise Data Management EMEA
Southern Europe
2
(No Transcript)
3
Agenda

• Background on BMC Software and Oracle
• Market Overview
• Corporate and Data Management Challenges
• BMC Softwares SmartDBA Solutions for Databases
• Summary

4
Strategic Alliance

• Market-leading ISV for database platforms
• Leading provider of software for e-business
• Second largest software company
• Major presence in Fortune 500
• Global market coverage
• Co-sponsor of www.dbazine.com

• Leading provider of enterprise management
• Market-leading ISV for database tools and
  utilities
• First ISV to supply 3rd party tools utilities
  for Oracle
• Major presence in Fortune 500
• Global market coverage
• Sponsor of www.dbazine.com

5
What are we hearing
Customers, suppliers and internal staff expect
faster, immediate access to data and the
expectation is that these demands be met while
reducing costs to the business.
6
Data Management Challenges
Manage Data Growth

• Global 2000 companies double the amount of data
  they own every year.
• Mike Ruettgers, CEO
• EMC Corporation

Key points Complexity, data growth and pace of
change, Reduced IT budgets
7
Optimising Data Management

• Reduce Costs and
• Improve Service Delivery

Technology budgets might be flat, but demands
for business agility and faster innovation
persist. That's the dilemma for IT executives
How do they manage company expectations while
faced with budget restrictions? Budget
Constraints Call For More Collaboration
InformationWeek
8
Top CIO Challenges

• Improving Service Delivery
• The majority of service level breaches are
  database related
• The data embodies the intellectual property of
  any complex organization
• Loss of business data can lead to business
  failure
• Reducing Cost
• Need to meet the demands of data availability and
  accuracy while reducing cost to the business
• Need to leverage investments and personnelDo
  more with less

9
Business Service Management
Linking Business and Technology
DB2 UDB os/390 and z/OS
Optimize
Simplify
Assure
PERFORMANCE
ADMINISTRATION
RECOVERY
Sybase
Sybase
Oracle
Oracle
IMS
IMS
SQL Server
SQL Server
DB2 UDB Unix and Windows
DB2 UDB os/390 and z/OS
IT Operations and Infrastructure Management
10
So what is SmartDBA?
SmartDBA enables customers to manage their data
effectively - ensuring quality of service,
maximizing availability and reducing costs
SmartDBA is the Data Management in BSM
11
Better Service at Lower Cost

• Avoid Downtime
• Unplanned
• Database Recovery
• Proactive Problem Diagnosis
• Planned
• Database Backup
• Space Management
• Schema Change Management
• Optimize Performance

12
Data Management Challenges
Managing Diverse Environments for Optimal
Performance and Availability
13
The Database Race is On

• DB2 Version 8 self managing
• Oracle 10g are you ready for the grid?
• Microsoft SQL Server 2000 scalability and
  reliability for the agile enterprise
• Sybase 12.5.1 truly scalable, self managing

Average large corporation owns 3-4 different
database brands
14
Critical Success Factors
due to budget cutbacks, organizations are
confronted with managing more data with limited
resources," said Ray Paquet, vice president,
research director for Gartner. "Whether running
Oracle, DB2 or SQL Server, or all three, the
ability to cross-train the staff to manage all
flavors will greatly enhance worker versatility
and productivity
15
BMCs Solution Strategy

• DBA focused environment to optimize performance,
  automate administration, and assure recovery
  across the enterprise
• Provide a single enterprise-wide integrated Web
  data management environment
• Management of all major platforms DB2, IMS,
  Oracle, MS SQL Server, Sybase
• Built-in Intelligent Advisors

16
Integrated Solution Set
IMS
DB2 S/390

• Fully integrated solution sets
• Shared data increases value of solution with each
  added product
• Common tools and processes across RDBMS types

17
Better Service with SmartDBA

• SmartDBAPerformance Management
• SmartDBA Cockpit
• DBXray
• PATROL for Database
• SQL-Explorer
• Space Expert

• SmartDBA Administration
• SmartDBA Cockpit
• DBA workbench for daily database and user
  administration
• Change Manager
• Advance Schema Management

• SmartDBABackup Recovery
• SmartDBA Cockpit
• SQL-BackTrack

Oracle and UDB Only
18
BMCs Product Heritage

• Heterogeneous support with a common experience
  across major platforms
• Deeper functionality than native tools
• Real life production capability and knowledge
• Market proven - 1 tools and utilities vendor
• Intelligent automated solutions

19
Database Monitoring and Diagnostics

• The Smart DBA Solution
• Overall view of database health
• Automated alerts and notification--Anywhere,
  anytime access
• Database Monitor Integrated to SmartDBA Expert
  solutions
• Integration to focus on fixing the problem

DBXray or SmartDBA for Patrol (Database KM)
20
How we compliment PATROL
PATROL Systems Management View
SmartDBA Database Management View
Monitors
Optimizes Performance
Service Levels
Simplifies Administration
DATABASE
Applications
Database
Assures Recovery
Systems
DB2 UDB, Oracle, MS SQL Server, Sybase
OS
Network
MS Windows, UNIX
21
Space Management

• The Smart DBA Solution
• Automatically identifies objects that require
  maintenance
• Best Reorg No Reorg
• Intelligently adjusts storage parameters to
  minimize repetitive maintenance activity
• Automates and validates task is necessary and
  that it will complete successfully
• Fastest and most reliable reorganization engine
• New update/insert reorganization capability

Space Expert
22
Are you running SAP on Oracle?
The normal cost of disk storage (EMC, Hitachi,
etc) is 40-100 Euros per GB. Many customers have
justified the purchase of Space Expert just on
the savings associated with disk usage alone.

• How can I make better use of my Oracle database?
  How can I contain growth and avoid disk
  purchases?
• Problem
• SAP has thousands of objects
• SAP is usually business critical (no downtime
  allowed)
• Hard to know what objects need to be reorganized
• Not reorganizing leads to poor performance,
  which affects the business
• Solution
• Space Expert for Oracle
• Finds space problems
• Fixes without downtime
• Online Reorg
• Can do things that even Oracle cannot do
• Online reorg of Long and Raw Data types
• Result better performance, reclaim disk space
  (costs )

23
SQL Tuning

• The Smart DBA Solution
• Automatically tune SQL rewrites for faster
  access
• High Speed Data collector adds no overhead
• Simulation facility permits non-intrusive tuning
  that emulates the production environment
• Recommend index changes based on application
  activity
• Only way to tune vendor supplied applications

SQL Explorer
24
SmartDBA Performance Solutions
What is SmartDBA Performance Management?

• Scalable, Web Based DBA products tightly
  integrated to provide
• Complete, Proactive Performance Management
• Enterprise Database Monitoring Alerting
• Diagnostics Information on the Problem
• SQL Analysis and Tuning
• Space and Object Management

25
The SmartDBA Difference
Integration Speeds Resolution
Enterprise Database Monitoring Alerting
Diagnostics Information on the Problem
SQL Analysis and Tuning
Space and Object Management
Problem Identification
Solution Validation
Diagnose Cause
Recommend Action
Find It, Fix It, Avoid It
26
Recovery

• The Smart DBA Solution
• Many features designed to automate and reduce the
  time it takes to run back-ups
• Assure recoveries are fast and accurate Guided
  Recovery
• Easier to Set Up, Use and Maintain
• Single solution for multiple platforms
• Integrated with File System Back-up utilities
• High availability solution for Oracle-Enterprise
  Snapshot

SQL Backtrack
27
People are talking about Recovery

• Gartner Group Analysts recommend
• Best practice 1 Standardize on products
• Across the enterprise DB2, IMS, MS SQL Server,
  UDB, Sybase
• Best practice 2 Focus on Recovery
• Backup is only as good as the recovery it
  provides!
• Source Ten best practices for enterprise backup
  recovery April 17, 2002 Tech Republic

Bottom lineRecovery is a critical service
delivered by IS organizations. Following these
top 10 best practices will help enterprises lower
their backup and storage total cost of ownership
and deliver higher-quality recovery services.
28
The SmartDBA Solution Strategy

• Provide Commonality among database management
  tools regardless of platform
• Multi-platform, consistent, integrated interface
• Provide tools that are intuitive, easy to use and
  deploy
• Provide scalable solutions for the Enterprise
• Automate most common DBA tasks
• Build Expertise into products - Intelligence
• Provide necessary information to enable DBAs to
  perform analysis to make informed decisions
• Enable teamwork through sharable knowledge base

29
SmartDBA Solutions
30
Reducing Resource Costs for Recovery

• Database-Aware Compression
• Provides 31 compression on-the-fly at backup
  time
• Automated Script Generation
• easily integrate SQL-BackTrack advanced backup
  and recovery features within your environment
• Automated Log Management
• Identifies and retains required logs
  automatically
• Provides user defined log expiration

31
Reduce Costs of Downtime

• Guided Recovery walks user through optimal
  recovery scenario to reduce recovery time
• Physical recoveries of full, incremental, and
  delta backups
• Table Level Extraction to recover logical objects
  directly from physical backup while your database
  is online or direct extracted data to a file!

32
Reduce Costs of Downtime

• Dry-Run Recovery verifies recovery scenario
  before execution to ensure successful recovery
  without impacting production
• Restartibility allows complex recoveries to be
  restarted near point of interruption
• Striping increases backup and recovery speed by
  moving data to/from multiple devices
  simultaneously
• Automated Redirected Restore easily restore
  backups to different database containers

33
Additional Costs Savings

• Seamless Integration with
• Tivoli Storage Manager
• Legato
• Veritas
• Recovery to Alternate Database, Instance, or Host
  provides powerful recovery options for your
  disaster recovery and migration strategies.
• Backup Cloning sends copies of database and/or
  log backups to multiple locations at backup time
  (will automatically switch to cloned backup if
  primary is unavailable!)

34
Cost Reductions in Script Management

• Automated Proactive Problem Determination
• Eliminating the need to write and maintain
  complex scripts for monitoring and problem
  diagnosis
• Multiple database versions and types
• Multiple operating systems versions and types
• Monitoring all critical components
• Proactive alert notification
• Email, pager, or visual

35
Hardware Cost Avoidance

• Optimizing Performance of Application
• Using low overhead collection technology
• Finding and tuning problematic SQL statements
• Optimizing Performance of Database
• Using low overhead collection technology
• Automatically identifies performance problems
• Understands application specific trends
• Recommends changes to reduce need for future
  maintenance
• Automates the database reorganization process
• Reclaim costly disk space

36
Enterprise Data Management

• Data Management Anytime, Anywhere
• Performance, Administration and Recovery of
  complex database environments
• Highly Intelligent, Automated and Integrated
  Solutions

IDC Says
Source IDC
BMC Softwares Market share grew from 60 to 70
2000 - 2001
37
Visit www.dbazine.com
38
Customer Benefits

• Improved service levels
• Ensure highest availability at lower cost
• Faster identification and resolution of IT
  problems
• Process improvement
• Improved visibility of Quality of Service (QoS)
  and Quality of Response (QoR) to the Business
  Owners
• Reduced costs
• Standardizing on an interoperable solution drives
  down training and support costs
• Lower administration, development and maintenance
  costs
• Lower problem resolution costs
• Stronger ROI
• Eliminate requirement for manual script
  generation to free up DBA for other strategic
  tasks
• Enable DBAs to quickly support new applications
  regardless of RDBMS platform

39

• Questions??

http//www.bmc.com/database