1 / 24

XIr2 Recommended Performance Tuning

XIr2 Recommended Performance Tuning. Andy Erthal BI Practice Manager. Performance Tuning Defined. Performance tuning is the improvement of system performance. The motivation for tuning can be real (it’s slow now) or anticipated (adding users). As load increases, performance decreases.

fordon
Download Presentation

XIr2 Recommended Performance Tuning

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. XIr2 Recommended Performance Tuning Andy Erthal BI Practice Manager

  2. Performance Tuning Defined Performance tuning is the improvement of system performance. • The motivation for tuning can be real (it’s slow now) or anticipated (adding users). • As load increases, performance decreases. • The ability to accept a higher load is called scalability

  3. Systematic Tuning Systematic tuning follows these steps: • Assess the problem and establish numeric values that categorize acceptable behavior. • Measure the performance of the system before modification. • Identify the part of the system that is critical for improving the performance. This is called the bottleneck. • Modify that part of the system to remove the bottleneck. • Measure the performance of the system after modification

  4. Universe Design • A separate discussion on optimizing SQL • Follow best practices • Use Indexes, aggregates, shortcuts, etc. • Apply row and time limits • Train your users on not only how to build reports, but how to use specific universes

  5. Report Efficiency and Schedules • Verify reports are built according to best practices (you do have these?) • Your BI Center of Excellence can help • Audit the system for report usage, etc. • Can some reports be scheduled? • Audit the report schedules

  6. Database resources / data models • DB server percent utilization? • What else is running on it? • Is the data model for OLTP or queries? • Index’s? • Extra summary tables • Number of DB connections

  7. Repository • Move the repository to a separate server • For the Database • For the File Store

  8. Split Web and Application Servers • Are you running Tomcat standalone? • If yes, then add an HTTP server. • This lets the application server focus on what it is good at, code translation, and lets the HTTP server handle HTML and image requests. • Put each on separate servers • Turn off IIS if not in use.

  9. Add another Tomcat instance • Add another Tomcat instance • For failover • To maximize server memory (Tomcat has a max of 1024MB JVM)

  10. Tomcat Settings The Tomcat server.xml file allows you to configure Tomcat using a simple XML descriptor. This is usually locate din the conf directory. The following changes should be made.

  11. Java Heap Memory • Maximum / Initial Heap Size • Default is: Max - 64 MB / Initial - 64 MB • Max: Raise this to 1024 MB – 2048 MB • Initial: Raise this to 512 MB • Example: -Xmx1024m • Server Mode • Instructs the JVM to perform more extensive run-time optimization. • Example: -Xmx1024m -server

  12. Closing Sessions with the Browser • When a user closes their browser while they have an active session, the session will remain active. • User setting in XIr2 to “Always log me off” • Bypassed with SSO • No global setting, but . . . • Performance Manager has a utility for this • pmxir2_deployment_guide.pdf

  13. Moving XSL transformation to IE • Available in IE 6 or higher • Delegates XML to XSL conversion to IE • Lightens the load on the server • WebI Viewing • xir2_bip_deploy_en.pdf • EPM • xir2_epm_setup_en.pdf

  14. View the last scheduled instance • For a list of reports, the default is to open the document as it was last saved • Some users will open this, then refresh it • You an change the default to open the latest instance • CMC -> Business Objects Enterprise Applications -> InfoView

  15. Sharing Data between reports • Only applies to Crystal Reports and DeskI • Disabled by default • Permits different users accessing the same report object to use the same data when viewing or refreshing a report. • Reduces the number of database calls • Reports generate faster

  16. Performance Management Tracing • Tracing is turned on by default • Not auditing • Low level debug activity • Impacts performance • I recommend turning this off • If used, monitor disk usage / space

  17. Use Server Groups • Server groups can be used to direct report processing to a specific set of servers • Organizes servers into sub-groups that can be managed and used independently • Dedicate resources to a particular set of users and/or applications

  18. Server Hardware • Upgrade you server hardware • New box with faster CPU’s • Increase the RAM (min 2 GB per CPU) • Fast disks

  19. Upgrade to SP2 • Many buy fixes • New features • Improvements in the Import Wizard • Improved DeskI to WebI conversion

  20. Change the Server Defaults • What type of environment do you have? • Disable Services that are not needed • DeskI or Crystal if not used • Set server parameters • DeskI is set to 5 by default

  21. Job Server Defaults • Job Servers kick off scheduled jobs • The Reports Servers run the reports • WebI, DeskI and Crystal each have their own Job Server • The default is set to five • This can be increased in most environments

  22. Report Server Defaults • Report Servers run the jobs • WebI, DeskI and Crystal each have their own Report Server • Maximum Simultaneous Report Jobs is the most important parameter to set • Different for each server and environment • Capacity planning helps here • One for each CPU

  23. References • 11 Years BOBJ Experience • Deployment Guide • Administration Guide • Recommended Settings Guide

  24. Questions? • Feel free to contact: Andy Erthal BI Practice Manager Andy_Erthal@hotmail.com (314) 409-4114

More Related