Storage Secrets for DBAs: What your storage administrator doesnt - - PowerPoint PPT Presentation

<Insert Picture Here>

Storage Secrets for DBAs: What your storage administrator doesn’t want you to know

Jagan Athreya Sriram Palapudi Director, Product Mgmt Consulting Member of Technical Staff Oracle Oracle

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any

• contract. It is not a commitment to deliver any

material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

28% 49% 73% 87% 0% 50% 100%

Consistent end-to-end application and service performance guarantees Unplanned infrastructure changes resulting in incidents and downtime Unanticipated infrastructure effects from consolidation & new application projects Misconfiguration of network objects First-class application management is critical to IT and business effectiveness

Top Challenges for Enterprise IT Managers

Source: Forrester Research, Top Five Challenges For Enterprise IT Infrastructure Managers — And How To Resolve Them, Thomas Mendel, March 2005

Oracle Vision – Managing the Business Value Stack

Cross-Layer Management Mapping & Management Mapping & Management Mapping & Management Mapping & Management

Networking Devices Routers, Switches, VOIP… Storage Devices NAS, SAN… Servers/OS Linux, Unix, Win, Virtual… Infrastructure Components Application Components Middleware Portals, AS, WS, ESB… Databases Oracle, Other Infrastructure Services IMAP, LDAP, DNS… Enter Order Notify Customer Reserve Stock Arrange Delivery Business Processes (Examples) Check Credit Application Software Custom & Composite Apps Based on Java/.Net, BPEL… Oracle Packaged Apps Siebel, PeopleSoft, EBS… Other Apps SAP, Exchange, Legacy Customer Service Order Fulfillment Product Catalog Application Business Services (Examples) Inventory Mgmt Shipping Returns Billing

Oracle Strategy – Top-Down Application Management

• Discovery & mapping of application services, business services and business processes
• End-user Experience Mgmt and App Diagnostics (Application Performance Management)
• Business-centric Monitoring, Service Level Mgmt, Transaction Mgmt. and Reports
• Middleware Management
• Database Management
• Server/OS Management
• Storage Management
• Network Management
• Testing, Provisioning, Patching
• Incident & Problem Management
• Availability & Performance Mgmt
• Change, Config & Release Mgmt
• Access, Usage & Compliance

Management of application

• perational lifecycle

Management of underlying IT components (stack) Management of services

• ffered to business users

Key Differentiator Integrated, end-to-end management of business services, applications and application infrastructure

LOB Managers Business Analysts IT/Business Liaisons Enterprise Architects DB Admin System Admin Storage Admin Network Admin App Manager Cust. Support Security Admin CAB & Auditors

Application Infrastructure Management

Broad management for all application-dependent components

Databases Databases Middleware Middleware Extended Infrastructure Management Extended Infrastructure Management Network Network Storage Storage Operating Operating Systems Systems Servers Servers

• Dell PowerEdge
• Linux
• All Unix
• Microsoft
• Oracle
• IBM DB2
• MS SQL Server

(2000 & 2005)

• Sybase
• Oracle
• IBM WebSphere
• BEA WebLogic
• MS .NET
• MS BizTalk Server
• MS IIS
• MS Commerce Server
• MS ISA Server
• MS Active Directory
• JBoss AS
• IBM MQ Series
• Citrix Presentation Server

(partner-built)

• Blue Lane PatchPoint

(partner-built)

• Tomcat
• Check Point Firewall
• Juniper Netscreen Firewall
• F5 BIG-IP
• Nortel Alteon Switch

(partner-built)

• NetApp Filer
• EMC Celerra, Clariion,

Symmetrix

• Pillar Axiom (partner-built)
• Onaro SANScreen

(partner-built)

Applications Applications

• Oracle
• Microsoft Exchange
• SAP

Virtual Servers Virtual Servers

• VMWare
• Oracle VM

What is in your Storage System?

Disks Disk Adapters Cache Front Adapters Processors

Storage – Host – Database

Mapping databases to storage

Disks Hypers/ MetaLUN Volumes/ Filesystems/ Diskgroups Tablespaces Datafiles

Storage – Host – Database

PROACTIVE

• Database Layout on Storage
• Storage Capacity

REACTIVE

• Storage System Performance
• Storage Configuration

Today’s mission

• Maximize the Storage System performance and

capacity for your databases

• Work more effectively with your Storage Administrator

to deliver higher quality of service to business users.

Enterprise Manager Storage Monitoring Plug-ins Available today

• EMC CLARiiON
• EMC Symmetrix
• EMC Celerra NAS
• NetApp Filer

Storage – Host – Database

PROACTIVE

• Database Layout on Storage
• Storage Capacity

REACTIVE

• Storage System Performance
• Storage Configuration

Storage Performance

Hypers/ MetaLUN Volumes/ Filesystems/ Diskgroups Datafiles Tablespaces Disks HR Finance Order Entry

Database performance – ADDM

SQL Advisor High-load SQL IO / CPU issues RAC issues Automatic Diagnostic Engine Snapshots in Automatic Workload Repository Self-Diagnostic Engine

System Resource Advice Network + DB config Advice

ADDM Log File

Host and ASM Metrics

• Disk Activity
• Average Disk I/O Service Time

(ms)

• Disk Block Writes (per second)
• Disk Blocks Reads (per

second)

• Disk Device Busy (%)
• Disk Reads (per second)
• Disk Writes (per second)
• Disk Group/ Disk

Performance

• I/O per second
• IO Throughput
• Read Response Time
• Read Throughput
• Reads per second
• Response Time
• Write Response Time
• Write Throughput
• Writes per second

Host ASM

Storage Performance

0049:13B:1

Hyper FrontEnd Director Port

Hyper Performance

0049:13B:1

Front End Director Performance

0049:13B:1

FrontEnd Director Port

Database mapping report

File Systems RAW Devices Volume Managers ASM Disk Groups ASM Disks RAC Databases Single Instance

Storage – Host – Database

PROACTIVE

• Database Layout on Storage
• Storage Capacity

REACTIVE

• Storage System Performance
• Storage Configuration

Configuration Management

Know what you have and know what you’re running

• Storage Microcode Version
• Model
• Model Type
• Agent Version
• Cache Read State
• Firmware Version
• Cache Information
• Disk Status
• Disk Capacity
• Total Capacity
• Number of Storage Processors
• Number of Disks
• Number of Spare Disks
• Parity Raid Configuration
• Raid5 Configuration

Configuration Management Database (CMDB)

Software Installations SW and HW Configurations Resource Relationships Certified Configurations Best Practices

• CMDB reports
• CMDB Statistics
• Policy standards
• Audit Reports
• Decision support

for incident, problem, change, and release management

Storage system errors

Disks : Data Sector Invalidations, RAID Errors, Spares Availability Disk Adapters : Status and Availability Storage Health Status Fans Status Processors Status, Temperature, Cache Performance Fabric Errors Front End Adapters : Status (Active, Failed) Ports Online, Dead,Offline)

Storage – Host – Database

PROACTIVE

• Database Layout on Storage
• Storage Capacity

REACTIVE

• Storage System Performance
• Storage Configuration

Database Layout

Considerations

• LUNS spread across disks
• Proper raid protection
• IO throughput spread over Front-end Ports
• Disks spread over disk adapters
• Databases sharing storage disks, front-end ports
• Host volume usage

Database Layout

Hypers/ MetaLUN Volumes/ Filesystems/ Diskgroups Datafiles Tablespaces Disks

Skewed

Database Storage Layout

Spread across FA, Ports Raid Protection

Database Storage Layout

Host Volume Sharing

Storage – Host – Database

PROACTIVE

• Database Layout on Storage
• Storage Capacity

REACTIVE

• Storage System Performance
• Storage Configuration

Storage Capacity analysis

Storage Used Free Database Balanced Database Under- Capacity Over- Capacity ASM Database Balanced Storage Used Free

Storage Plug-in Architecture

• READ-only view of Storage
• Agent collects Storage metrics –

real time and historic

• Single agent for multiple arrays

EM OMS Repository

EM Client

Config/Metric/Report/ Alert Information using Browser

• Configurable collection frequency
• Negligible impact on storage array
• Hot-upgradeable architecture
• Native Storage CLI Calls

Host Host

DB/ASM/Host Information using EMAGENT

ASM/DB ASM/DB Storage System

Plug-in Security

Storage Security

• Monitor only
• Separate OS user for metric collection scripts
• “Read-only” user for collection

EM Security

• Users and Roles limiting access to Storage targets
• View Privileges

Personalization

Topological View of the System

Personalization

Specify the metric for the alerts that are of interest

EM System Charts Setup

View charts of related targets on one screen DB Host Storage

Storage plug-in Benefits

• Faster root-cause-analysis through end-

to-end tracing of dependent storage components

• Quicker diagnosis through correlated

performance metrics across db, host and storage

• Higher quality of service through single

unified view of database, host and storage

• Higher ROI through improved utilization of

storage space

Celerra Clariion Symmetrix