storage secrets for dbas what your storage administrator
play

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

<Insert Picture Here> Storage Secrets for DBAs: What your storage administrator doesnt want you to know Jagan Athreya Sriram Palapudi Director, Product Mgmt Consulting Member of Technical Staff Oracle Oracle The following is


  1. <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

  2. 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.

  3. 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

  4. 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…

  5. 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

  6. 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)

  7. What is in your Storage System? Front Adapters Processors Cache Disk Adapters Disks

  8. Storage – Host – Database

  9. Mapping databases to storage Volumes/ Hypers/ Disks Datafiles Filesystems/ Tablespaces MetaLUN Diskgroups

  10. Storage – Host – Database PROACTIVE REACTIVE • Database Layout on Storage • Storage System Performance • Storage Capacity • Storage Configuration

  11. 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.

  12. Enterprise Manager Storage Monitoring Plug-ins Available today • EMC CLARiiON • EMC Symmetrix • EMC Celerra NAS • NetApp Filer

  13. Storage – Host – Database REACTIVE PROACTIVE • Storage System Performance • Database Layout on Storage • Storage Configuration • Storage Capacity

  14. Storage Performance Volumes/ Hypers/ Disks Filesystems/ Datafiles Tablespaces MetaLUN Diskgroups HR Finance Order Entry

  15. 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

  16. 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

  17. Storage Performance 0049:13B:1 FrontEnd Port Hyper Director

  18. Hyper Performance 0049:13B:1

  19. Front End Director Performance 0049:13B:1 FrontEnd Port Director

  20. Database mapping report RAC Databases ASM Disk Groups File Systems Single Instance ASM Disks RAW Devices Volume Managers

  21. Storage – Host – Database REACTIVE PROACTIVE • Storage System Performance • Database Layout on Storage • Storage Configuration • Storage Capacity

  22. 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)

  23. 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

  24. Storage – Host – Database REACTIVE PROACTIVE • Storage System Performance • Database Layout on Storage • Storage Configuration • Storage Capacity

  25. 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

  26. Database Layout Volumes/ Hypers/ Disks Filesystems/ Datafiles Tablespaces MetaLUN Diskgroups Skewed

  27. Database Storage Layout Spread across FA, Ports Raid Protection

  28. Database Storage Layout Host Volume Sharing

  29. Storage – Host – Database REACTIVE PROACTIVE • Storage System Performance • Database Layout on Storage • Storage Configuration • Storage Capacity

  30. Storage Capacity analysis Free Free Database Balanced Used Under- Capacity Database Over- Storage Capacity Balanced Database ASM Used Storage

  31. 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

  32. 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

  33. Personalization Topological View of the System

  34. Personalization Specify the metric for the alerts that are of interest

Recommend


More recommend