1 / 56

Infrastructure Preparations for Oracle/Hyperion EPM 11.1.2.2

Infrastructure Preparations for Oracle/Hyperion EPM 11.1.2.2. Charles Naslund Indigo New Zealand 18 th of March 2013. Agenda. Current EPM 11.1.2.2 Architecture Preparations “Why Should I Care? ” Server Sizing Tuning for stability and performance Q&A. Agenda.

shayla
Download Presentation

Infrastructure Preparations for Oracle/Hyperion EPM 11.1.2.2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Infrastructure Preparations for Oracle/Hyperion EPM 11.1.2.2 Charles Naslund Indigo New Zealand 18th of March 2013

  2. Agenda • Current EPM 11.1.2.2 Architecture • Preparations “Why Should I Care?” • Server Sizing • Tuning for stability and performance • Q&A

  3. Agenda Current EPM Architecture

  4. Oracle/Hyperion EPM Architecture Technical Architecture HTTP Server (IIS, Apache, OHS)

  5. Oracle/Hyperion EPM Architecture Technical Architecture HTTP Server (IIS, Apache, OHS) Shared Services (Foundation)

  6. Oracle/Hyperion EPM Architecture Technical Architecture HTTP Server (IIS, Apache, OHS) Workspace Shared Services (Foundation)

  7. Oracle/Hyperion EPM Architecture Technical Architecture HTTP Server (IIS, Apache, OHS) Workspace Planning EPMA(Web App, Data Sync) FinancialReportingWeb WebAnalysis OBIEE Calc Mgr. Shared Services (Foundation)

  8. Oracle/Hyperion EPM Architecture Technical Architecture HTTP Server (IIS, Apache, OHS) EssbaseProviderSvcs Workspace Planning EPMA(Web App, Data Sync) EssbaseAdminServices FinancialReportingWeb WebAnalysis OBIEE EssbaseStudioServer Calc Mgr. Shared Services (Foundation)

  9. Oracle/Hyperion EPM Architecture Technical Architecture HTTP Server (IIS, Apache, OHS) EssbaseProviderSvcs Workspace Planning EPMA(Web App, Data Sync) EssbaseAdminServices FinancialReportingWeb WebAnalysis InteractiveReporting Financial Reporting Svcs OBIEE HFM/FDM COM Server EssbaseStudioServer EPMA Dim Svr Workspace Agent Service Calc Mgr. Shared Services (Foundation)

  10. Oracle/Hyperion EPM Architecture Technical Architecture HTTP Server (IIS, Apache, OHS) EssbaseProviderSvcs Workspace Planning HFM/FDMWeb HFM/FDMWeb EPMA(Web App, Data Sync) EssbaseAdminServices FinancialReportingWeb WebAnalysis InteractiveReporting EPMA Dim Svr Financial Reporting Svcs OBIEE HFM/FDM COM Server EssbaseStudioServer EPMA Svc Mgr Workspace Agent Service Calc Mgr. Shared Services (Foundation)

  11. Oracle/Hyperion EPM Architecture Technical Architecture HTTP Server (IIS, Apache, OHS) EssbaseProviderSvcs Workspace Planning HFM/FDMWeb EPMA(Web App, Data Sync) EssbaseAdminServices FinancialReportingWeb WebAnalysis InteractiveReporting EPMA Dim Svr Financial Reporting Svcs OBIEE HFM/FDM COM Server EssbaseStudioServer EPMA Svc Mgr Workspace Agent Service Calc Mgr. Shared Services (Foundation) Essbase Server

  12. Oracle/Hyperion EPM Architecture Technical Architecture HTTP Server (IIS, Apache, OHS) EssbaseProviderSvcs Workspace Planning HFM/FDMWeb EPMA(Web App, Data Sync) EssbaseAdminServices FinancialReportingWeb WebAnalysis InteractiveReporting EPMA Dim Svr Financial Reporting Svcs OBIEE HFM/FDM COM Server EssbaseStudioServer EPMA Svc Mgr Workspace Agent Service Calc Mgr. Shared Services (Foundation) ODIAgent Essbase Server

  13. Oracle/Hyperion EPM Architecture Technical Architecture HTTP Server (IIS, Apache, OHS) EssbaseProviderSvcs Workspace Planning HFM/FDMWeb EPMA(Web App, Data Sync) EssbaseAdminServices FinancialReportingWeb WebAnalysis InteractiveReporting EPMA Dim Svr Financial Reporting Svcs OBIEE HFM/FDM COM Server EssbaseStudioServer EPMA Svc Mgr Workspace Agent Service Calc Mgr. Shared Services (Foundation) ODIAgent Essbase Server

  14. Oracle/Hyperion EPM Architecture Technical Architecture ClientLayer API, RMI, HTTP(S) DCOM HTTP(S) HTTP Server (IIS, Apache, OHS) EssbaseProviderSvcs Workspace ApplicationLayer Planning HFM/FDMWeb EPMA(Web App, Data Sync) EssbaseAdminServices FinancialReportingWeb WebAnalysis InteractiveReporting EPMA Dim Svr Financial Reporting Svcs OBIEE HFM/FDM COM Server EssbaseStudioServer EPMA Svc Mgr Workspace Agent Service Calc Mgr. Shared Services (Foundation) JDBC, OLE DB TCP/IP DatabaseLayer ODIAgent Essbase Server

  15. Agenda Preparations “Why Should I Care?”

  16. Preparations “Why Should I Care?” • "When you're prepared, you're more confident. When you have a strategy, you're more comfortable.“(Fred Couples)

  17. Preparations “Why Should I Care?” • Things to consider before Installation • Infrastructure Needs • Servers • Network • Databases • Workstations

  18. Preparations “Why Should I Care?” • Infrastructure NeedsServers • Virtual or Tin? • Sizing Criteria • Number of simultaneous users • Application Demand • Type of Application • HFM • Planning

  19. Preparations “Why Should I Care?” • Infrastructure NeedsServers • Application Demand • HFM • Primary Load on Relational DB • Secondary Load on Application Server • Light Load on Web • Planning • Primary Load on Essbase Server • Secondary Load on Web/Application • Light Load on Web

  20. Preparations “Why Should I Care?” • Infrastructure NeedsServers • Application Demand • Reporting Use • Financial Reporting Load • HFM Data Source • Planning Data Source • Web/Application Server • Workspace • Financial Reporting Web

  21. Preparations “Why Should I Care?” • Infrastructure NeedsServers • Application Demand • Reporting Use • Reporting and Analysis Load • Reporting and Analysis Services • Data Source(s) • OBIEE Load • Web/Application Server • Data Source • Web Analysis • Web/Application Server • Data Source

  22. Preparations “Why Should I Care?” • Infrastructure NeedsServers • Sizing Criteria • SLA Requirements • Redundancy • Load Balancing

  23. Preparations “Why Should I Care?” • Infrastructure NeedsNetwork • Impact Criteria on Network • Bandwidth • HFM: • Avg 64 - 128KB • Planning: • Avg 32 – 64KB • SmartView: • Avg 28KB • Reporting: • Report Size • Report Books • PDF

  24. Preparations “Why Should I Care?” • Infrastructure NeedsNetwork • Impact Criteria on Network • Application Type • Web • Static Data Sizes • Java Script • Performance is sensative to latentcy. • DCOM • Variable network port usage • Latency affects performance and user experience • Recommend a maximum of 125ms for best user experience

  25. Preparations “Why Should I Care?” • Things to consider before Installation • Software Needs • Operating Systems (64 bit recommended) • Linux: • Redhat 4.x, 5.x • Oracle 4.x, 5.x • UNIX: • Solaris (2.9,10,11) • AIX (5.3, 6.1, 7.1) • HP-UX (11i) Itanium Only • Windows: • Server 2008 R2 (SP2+) • Server 2003 (SP3+) • Clients: XP (SP3+), 7, • Mac OS • OSX 10.6+ (Web Only)

  26. Preparations “Why Should I Care?” • Things to consider before Installation • Software Needs • Client Browsers • IE 7.x, 8.x, 9.x • FireFox 10x • Productivity Tool Support • MS Office Suites 2003, 2007, 2008(Mac), 2010 • Other Software • Adobe Reader • DCOM (Client and Server) • Flash • JRE 1.60_22+ • .NET 3.5+

  27. Preparations “Why Should I Care?” • Things to consider before Installation • Software Needs • Other Software • Application Servers • Weblogic 11gR1 (Licence Included) • 10.3.5 and 10.3.6 • Web Servers • Oracle HTTP Server 11gR1 • Microsoft IIS 6.0+ and 7.x • Websphere (Licenses Additional) • Newly supported with 11.1.2.2 • 7.0.0.19+ ND • Web Server • IBM HTTP Server 7.0+

  28. Preparations “Why Should I Care?” • Things to consider before Installation • Software Needs • A Database repository is required to support EPM metadata and security. • Supported Databases for Repositories • Oracle DB (10.2.0.4+, 11.1.07+, 11.2.0.1+) • Microsoft SQL Server (2005, 2008, 2008 R2) • IBM DB2 (9.7 FP3a, 9.5) • Most other database vendors are supported as datasources.

  29. Preparations “Why Should I Care?” • Things to consider before Installation • User Training • Administrator(s) • Oracle University: http://tinyurl.com/b2cajju • Training Venues • Virtual • Classroom • Self Taught • Onsite Indigo Training • Users • Oracle University: Depends on Product • EPM Classes URL: http://tinyurl.com/cyn59vf • Onsite Indigo Training

  30. Agenda Server Sizing

  31. Server Sizing 5 – 10 users

  32. Server Sizing 250 users

  33. Server Sizing 500 users

  34. Agenda Tuning for stability and performance

  35. Tuning for stability and performance • Tuning Platforms • Server Operating Systems • Web Servers • Application Servers • Oracle Databases • Client Operating Systems • Client Web Browsers

  36. Tuning for stability and performance • Tuning Platforms • Server Operating Systems • Windows Parameters • Linux Parameters • Unix Parameters

  37. Tuning for stability and performance • Tuning Platforms • Server Operating Systems • Windows Parameters • MaxUserPort (used to determine availability of user ports requested by applications such as smartview, planning, etc.) • Default: 16383 • Recommend: 65532 • Use Netsh command to configure start port and range • netshint ipv4 set dynamicporttcp start=1025 num=64508 • Note: Use netshint ipv4 show dynamicporttcpto determine dynamic port ranges • Receive Window Auto-Tuning Level • Win Server 2008 automatically adjusts TCP window scaling. • Some routers, firewalls, and OS’s are incompatible with it and could cause slow data transfer. • Disable TCP Auto-Tuning if your users experience slow network performance (ie: data sent very slowly or drops data occasionally • CMD: netsh interface tcp show global • Set power option setting to “High Performance” • Ref: http://support.microsoft.com/kb/2207548

  38. Tuning for stability and performance • Tuning Platforms • Server Operating Systems • Linux Parameters • Tcp_fin_timeout: • Default: 60 • Recommend: 30 • File Descriptors: (open files) • Default: 1024 • Recommend 8192 (64 bit) • Tcp_max_syn_backlog • Default: 1024 • Recommend 4096

  39. Tuning for stability and performance • Tuning Platforms • Server Operating Systems • Unix Parameters • Aix • Tcp_keepidle • Default:14400 (2 hours) • Recommend:600 (5 min) • Tcp_keepintvl • Default: 150 • Recommend 10 • Tcp_keepinit • Default: 150 • Recommend 40 • Listen Backlog • Default 1024 • Recommend 8192 • Socket Send and Receive Buffer Size • Check with IBM for optimal value for these values

  40. Tuning for stability and performance • Tuning Platforms • Server Operating Systems • Unix Parameters • Aix • User Limit Parameter • Set the following vlaues to Unlimited for 64-bit servers • Time (seconds) • File (blocks) • Data (kbytes) • Stack (kbytes) • Memory (kbytes) • Coredump (blocks) • Nofiles (descriptors) • Set to 8192 on 64-bit • SpinLooptime • Default: 40 • Recommend 600 • MALLOCOPTIONS • Set to multiheap:16

  41. Tuning for stability and performance • Tuning Platforms • Server Operating Systems • Unix Parameters • Solaris • File Descriptors (nofiles) • Default: 256 • Recommend: 16384 • Tcp_time_wait_interval • Default: 60000 • Recommend: 30000 • Tcp_xmit_hiwat and tcp_recv_hiwat • Calculated based on network bandwith and average latency • Recommend: (Bandwidth bits/sec) X ((Return Latency) X (8 bits/byte) • Solaris 9 Default = 48K • Very Fast Networks = >32K • Tcp_conn_hash_size • Default: 512 (Solaris 9, 0 in Solaris 10) • Recommend: 1024 (0 in Solaris 10) • Connection Backlog • Default 128 (max_q), 1024 (max_q0) • Recommend: 1024 (max_q), 4096 (max_q0)

  42. Tuning for stability and performance • Tuning Platforms • Web Servers • Oracle Https Server (OHS) • Settings are located in the Middleware_Home/user_projects_epmsystem1/httpConfig/ohs/config/OHS/ohs_component/http.conf file • For Windows Uset these settings

  43. Tuning for stability and performance • Tuning Platforms • Web Servers • Oracle Https Server (OHS) • Settings are located in the Middleware_Home/user_projects_epmsystem1/httpConfig/ohs/config/OHS/ohs_component/http.conf file • For Unix, use these settings

  44. Tuning for stability and performance • Tuning Platforms • Web Servers • IIS 7 • Idle timeout • Default Value: 20 • Recommend: 0 • Regular time Interval • Default: 1740 • Recommend 0 • minBytesPerSecond • Default: 240 • Recommended 50 • Connection Timeout • Default: 120 • Recommended 7200 • Private Memory and Virtual Memory Limit • Set to 0 (64bit only)

  45. Tuning for stability and performance • Tuning Platforms • Web Servers • HTTP Compression/Caching • What is it?

  46. Tuning for stability and performance • Tuning Platforms • Web Servers • HTTP Compression/Caching • Why use compression? • Saves network bandwidth • Improves request and response latency • Applications which benefit from compression • HFM • Planning Web Forms • Recommended only for Wide Area Networks, not LAN’s

  47. Tuning for stability and performance • Tuning Platforms • Application Servers • Oracle Weblogic • Increase the number of connection pool. • Use the Weblogic Administration Console to change the settings

  48. Tuning for stability and performance • Tuning Platforms • Application Servers • Oracle Weblogic • Tune 64bit Java Virtual Machines (JVM’s) • Jrocket JVM Settings • Sun JVM Settings

  49. Tuning for stability and performance • Tuning Platforms • Application Servers • IBM Websphere • Use the same settings as for Sun JVM

  50. Tuning for stability and performance • Tuning Platforms • Relational Databases • Oracle RDBMS • Init.Ora Settings • Processes=1500 • Set Open_Cursors=7000 • Set Cursor_Sharing=Force • Set Session_Cached_Cursors=100 • Set Optimizer_Index_Cost_Adj to 50 • Recommend that the DBA use the AWR and ADDM reports to analyze the user activity • As always, pay attention to the OS performance as well, especially CPU and RAM utilization on the DB Server

More Related