1 / 37

Performance Testing and OBIEE by ObieeTrainingClasses

We offer online IT training with placements, project assistance in different platforms with real time industry consultants to provide quality training for all it professionals, corporate clients and students etc. Special features by OBIEE TRAINING CLASSES are Extensive Training will be in both OBIEE Online Training and Placement. Training Features at OBIEE TRAINING CLASSES: We believe that online training has to be measured by three major aspects viz., Quality, Content and Relationship with the Trainer and Student. Not only our online training classes are important but apart from that the material which we provide are in tune with the latest IT training standards, so a student has not to worry at all whether the training imparted is outdated or latest. Course content: • Oracle Business Intelligence (OBIEE) • Using Administration Tool and Creating Repository 1. Building the Physical Layer of a Repository 2. Building the Business Model and Mapping Layer of a Repository 3. Building the Presentation Layer of a Repository 5. Creating Calculation Measures 6. Organizing the Presentation Layer   7. Using Initialization Blocks and Variables 8. Adding Multiple Sources 9. Executing Direct Database Requests 10. Using Aggregates 11. Creating Time Series Measures • Using Answers and Creating Interactive Dashboards 1. Creating an ODBC Data Source 2. Restoring the Business Intelligence Presentation Catalog and Updating Metadata 3. Creating a Query and a Chart 4. Working with a Pivot Table 5. Creating a Narrative View 6. Creating Column Selectors and View Selectors 7. Creating an Interactive Dashboard 8. Using Dashboard Prompts and Presentation Variables Please Visit us for the Demo Classes, we have regular batches and weekend batches. OBIEE ONLINE TRAINING CLASSES Phone: (404)-900-9988 Email: info@obieetrainingclasses.com Web: http://obieetrainingclasses.com

ObieeTrainingClasses
Download Presentation

Performance Testing and OBIEE by ObieeTrainingClasses

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. Performance Testing and OBIEE By OBIEE Training Classes Email : info@obieetrainingclasses.comContact : 404-900-9988Website : www.obieetrainingclasses.com

  2. Introduction • Oracle BI specialist at Morrisons plc • Big IT development programme at its early stages implementing OBIEE, OBIA, ORDM, all on Oracle 11g & HP-UX

  3. The aim of this presentation • A Performance Tuning Methodology • OBIEE techie stuff • Learn from my mistakes!

  4. What is performance testing all about? • Response times • Report • ETL batch • OLTP transaction • System impact • Resource usage • Scalability

  5. Why performance test?(Isn’t testing just for wimps?) • Check that your system performs • Are the users going to be happy? • Baseline • How fast is fast? • How slow is slow? • Validate system design • Do it right, first time • Capacity planning

  6. Why performance test? • It’s never too late • “You’ll never catch all your problems in pre-production testing. That’s why you need a reliable and efficient method for solving the problems that leak through your pre-production testing processes.”

  7. Why performance test? • Because it makes you better at your job • “At the very least, your performance test plan will make you a more competent diagnostician (and clearer thinker) when it comes time to fix the performance problems that will inevitably occur during production operation.”

  8. Performance Testing – What & Why • Quantifying response times • System impact • User expectations • Problem diagnosis • Design validation

  9. Performance Testing - How? Iterative approach Timebox! Do it right Don’t “fudge it” Evaluate design / config options Do more testing Redefine test Do more testing Be Methodical

  10. Define & build your test • Define – what are you going to test • Aim of the test • Scope • Assumptions • Specifics • Data, environment, etc • Build – how are you going to test it • OBIEE specific • E.g. : • Check that the system performs • Baseline performance • Prove system capacity • Validate system design

  11. Consider your test scope More components = more complex = more variables = larger margin of error Fewer components = easier to manage = more precise = more efficient

  12. OBIEE stack Report / Dashboard Rendered report Presentation Services Logical SQL Physical SQL statement(s) BI Server Data set Database Data set(s) Excludes App/Web server & presentation services plug-in

  13. Report / Dashboard OBIEE testing options Load Testing tool (eg. LoadRunner, OATS) User & Stopwatch Presentation Services Rendered report nqcmd LSQL SQL Client LSQL Physical SQL BI Server Physical SQL Data set Database Data set(s)

  14. nqcmd Usage Tracking or NQQuery.log BI Server Logical SQL Data Logical SQL Logical SQL Test script nqcmd

  15. nqcmd Master test script Test script nqcmd BI Server Test script Data nqcmd Logical SQL Test script nqcmd Test script nqcmd

  16. LoadRunnera.k.a. HP Performance Centre • Simulates user interaction – HTTP traffic • Powerful, but can be difficult to set up • Ajax complicates things • Do you really need to use it? • Tools • Fiddler2 • FireBug • Reference: • My Oracle Support – Doc ID 496417.1 • http://rnm1978.wordpress.com/category/loadrunner

  17. Defining your test - summary • Be very clear what the aim of your test is • You probably need to define multiple tests • Different points on the OBIEE stack to interface • Pick the most appropriate one • Write everything down!

  18. Measure

  19. OBIEE measuring & monitoring PerfMon (Windows) Enterprise Manager (Oracle) Server metrics e.g. : IO, CPU, Memory Web Server Apache log Oracle OS Watcher (unix) App Server OAS log Usage Tracking Presentation Services plug-in sawserver.log Analytics log Presentation Services NQServer.log Enterprise Manager NQQuery.log ASH, AWR, SQL Monitor BI Server Database PerfMon (windows only) systems management jConsole etc Enterprise Manager BI Management Pack Presentation services

  20. Oracle SQL Monitor

  21. Measure - summary • Lots of different ways to measure • Build measurement into your test plan • Automate where possible • Easier • Less error

  22. Analyse

  23. Analysing the data

  24. Analysing the data

  25. Analysing the data

  26. Analysing the data

  27. Analysing the data

  28. Analysing the data

  29. Recording data about the test

  30. Extending Usage Tracking OBIEE_REPLAY_STATEMENTS qt_ora_hash query_text saw_path dashboard S_NQ_ACCT START_TS ROW_COUNT TOTAL_TIME_SEC NUM_DB_QUERY QUERY_TEXT QUERY_SRC_CD SAW_SRC_PATH SAW_DASHBOARD OBIEE_REPLAY_STATS testid testenv qt_ora_hash start_ts response_time row_count db_query_cnt

  31. Analyse Iterative approach Do it right Don’t “fudge it” Evaluate design / config options Timebox!

  32. Review Iterative approach Redefine test Continue testing Implement

  33. Review

  34. Implement Iterative approach

  35. Lessons Learnt • You won’t get your testing right first time • There’s no shame in that • Don’t cook the books • Better to redefine your test than invalidate its results • Stick to the methodology • Don’t move the goalposts • Very tempting to pick off the “low-hanging fruit” • If you do, make sure you don’t get indigestion… • Timebox • Test your implementation!

  36. Performance Testing OBIEE Iterative approach Do it right Don’t “fudge it” Evaluate design / config options Do more testing Redefine test Do more testing Be Methodical

  37. Thank You!

More Related