<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.
Top Challenges for Enterprise IT Managers Consistent end-to-end application and 87% service performance guarantees Unplanned infrastructure changes 73% resulting in incidents and downtime Unanticipated infrastructure effects from 49% consolidation & new application projects 28% Misconfiguration of network objects 0% 50% 100% First-class application management is critical to IT and business effectiveness 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 Business Enter Notify Check Reserve Arrange Processes Order Customer Credit Stock Delivery (Examples) Mapping & Management Application Business Customer Product Inventory Order Shipping Billing Returns Cross-Layer Management Service Catalog Mgmt Fulfillment Services (Examples) Mapping & Management Application Custom & Composite Apps Oracle Packaged Apps Other Apps Software Based on Java/.Net, BPEL… Siebel, PeopleSoft, EBS… SAP, Exchange, Legacy Mapping & Management Middleware Databases Infrastructure Services Application Components Portals, AS, WS, ESB… Oracle, Other IMAP, LDAP, DNS… Mapping & Management Infrastructure Servers/OS Storage Devices Networking Devices Components Linux, Unix, Win, Virtual… NAS, SAN… Routers, Switches, VOIP…
Oracle Strategy – Top-Down Application Management LOB Business IT/Business Enterprise Managers Analysts Liaisons Architects • 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 Management of services offered to business users DB App Admin Manager Management of application Management of underlying operational lifecycle IT components (stack) System Cust. Admin Support • Testing, Provisioning, Patching • Middleware Management • Incident & Problem Management • Database Management Security Storage • Availability & Performance Mgmt • Server/OS Management Admin Admin • Change, Config & Release Mgmt • Storage Management • Access, Usage & Compliance • Network Management CAB & Network Auditors Admin Key Differentiator Integrated, end-to-end management of business services, applications and application infrastructure
Application Infrastructure Management Broad management for all application-dependent components Extended Infrastructure Management Extended Infrastructure Management Network Virtual Servers Network Virtual Servers Middleware Databases Databases Middleware • VMWare • Oracle VM • Check Point Firewall • Oracle • Oracle Operating Operating • Juniper Netscreen Firewall • IBM WebSphere • IBM DB2 • F5 BIG-IP Systems Systems • BEA WebLogic • MS SQL Server • Nortel Alteon Switch (2000 & 2005) • MS .NET • Linux (partner-built) • Sybase • MS BizTalk Server • All Unix • MS IIS • Microsoft Storage • MS Commerce Server Storage Applications Applications • MS ISA Server • MS Active Directory • JBoss AS Servers • IBM MQ Series Servers • NetApp Filer • Citrix Presentation Server • EMC Celerra, Clariion, (partner-built) Symmetrix • Oracle • Blue Lane PatchPoint • Pillar Axiom (partner-built) • Microsoft Exchange (partner-built) • Onaro SANScreen • SAP • Tomcat • Dell PowerEdge (partner-built)
What is in your Storage System? Front Adapters Processors Cache Disk Adapters Disks
Storage – Host – Database
Mapping databases to storage Volumes/ Hypers/ Disks Datafiles Filesystems/ Tablespaces MetaLUN Diskgroups
Storage – Host – Database PROACTIVE REACTIVE • Database Layout on Storage • Storage System Performance • Storage Capacity • 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 REACTIVE PROACTIVE • Storage System Performance • Database Layout on Storage • Storage Configuration • Storage Capacity
Storage Performance Volumes/ Hypers/ Disks Filesystems/ Datafiles Tablespaces MetaLUN Diskgroups HR Finance Order Entry
Database performance – ADDM Snapshots in Automatic Workload Repository ADDM Log File Automatic Diagnostic Engine Self-Diagnostic Engine High-load IO / CPU RAC issues SQL issues System Network + SQL Resource DB config Advisor Advice Advice
Host and ASM Metrics Host ASM • Disk Group/ Disk • Disk Activity Performance • Average Disk I/O Service Time (ms) • I/O per second • Disk Block Writes (per second) • IO Throughput • Disk Blocks Reads (per • Read Response Time second) • Read Throughput • Disk Device Busy (%) • Reads per second • Disk Reads (per second) • Response Time • Disk Writes (per second) • Write Response Time • Write Throughput • Writes per second
Storage Performance 0049:13B:1 FrontEnd Port Hyper Director
Hyper Performance 0049:13B:1
Front End Director Performance 0049:13B:1 FrontEnd Port Director
Database mapping report RAC Databases ASM Disk Groups File Systems Single Instance ASM Disks RAW Devices Volume Managers
Storage – Host – Database REACTIVE PROACTIVE • Storage System Performance • Database Layout on Storage • Storage Configuration • Storage Capacity
Configuration Management Know what you have and know what you’re running • CMDB reports • Storage Microcode Version • CMDB Statistics Software • Policy standards • Model Installations • Audit Reports • Model Type • Decision support • Agent Version for incident, SW and HW • Cache Read State problem, change, Configurations and release • Firmware Version management Resource • Cache Information Relationships • Disk Status • Disk Capacity Certified • Total Capacity Configurations • Number of Storage Processors Best • Number of Disks Practices • Number of Spare Disks • Parity Raid Configuration • Raid5 Configuration Configuration Management Database (CMDB)
Storage system errors Front End Adapters : Status (Active, Failed) Ports Online, Dead,Offline) Storage Health Status Fans Status Disk Adapters : Processors Status, Status and Availability Temperature, Cache Performance Fabric Errors Disks : Data Sector Invalidations, RAID Errors, Spares Availability
Storage – Host – Database REACTIVE PROACTIVE • Storage System Performance • Database Layout on Storage • Storage Configuration • Storage Capacity
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 Volumes/ Hypers/ Disks Filesystems/ Datafiles Tablespaces MetaLUN Diskgroups Skewed
Database Storage Layout Spread across FA, Ports Raid Protection
Database Storage Layout Host Volume Sharing
Storage – Host – Database REACTIVE PROACTIVE • Storage System Performance • Database Layout on Storage • Storage Configuration • Storage Capacity
Storage Capacity analysis Free Free Database Balanced Used Under- Capacity Database Over- Storage Capacity Balanced Database ASM Used Storage
Storage Plug-in Architecture EM OMS Repository DB/ASM/Host Information using EMAGENT Config/Metric/Report/ Alert Information using Browser Host Host EM Client ASM/DB ASM/DB Storage System • READ-only view of Storage • Configurable collection frequency • Agent collects Storage metrics – • Negligible impact on storage array real time and historic • Hot-upgradeable architecture • Single agent for multiple arrays • Native Storage CLI Calls
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
Recommend
More recommend