1 / 19

PeopleSoft Ping

PeopleSoft Ping. David Kurtz Go-Faster Consultancy Ltd. david.kurtz@go-faster.co.uk www.go-faster.co.uk. Resources. If you can’t hear me say so now. Please feel free to ask questions as we go along. The presentation will be available from Customer Connection –> Events -> UK Tech PUG

studs
Télécharger la présentation

PeopleSoft Ping

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. PeopleSoft Ping David Kurtz Go-Faster Consultancy Ltd. david.kurtz@go-faster.co.uk www.go-faster.co.uk

  2. Resources • If you can’t hear me say so now. • Please feel free to ask questions as we go along. • The presentation will be available from • Customer Connection –> Events -> UK Tech PUG • www.go-faster.co.uk www.go-faster.co.uk

  3. Independent consultant System Performance Tuning Oracle/Unix/Tuxedo PeopleSoft Apps www.ukoug.org Book www.apress.com Who am I? www.go-faster.co.uk

  4. It is a component which runs a ‘standard’ transaction and measures the duration of that transaction at each component in the PIA. What is PeopleSoft Ping? www.go-faster.co.uk

  5. What does PS Ping Measure? Browser/ Network Time Web Server Time Application Server Time Database Time Web Server Access Log Tuxedo Service Trace PeopleTools Trace Oracle SQL*Trace Application Server (application logic) DBMS (application data & meta-data Browser (presentation & JavaScript) Java Servlet (presentation logic) http / https Tuxedo Message SQL Screen Paint Java Script Servlet Thread APPQ PSAPPSRV www.go-faster.co.uk

  6. Where is PeopleSoft Ping? • DERIVED_PTP.HTMLCTLEVENT.FieldChange • Each ping saves the results from the previous ping to the database • PS_PTP_TST_CASES • Can get basic Ping graphs from PeopleSoft • Can’t control scale • I prefer to use Excel www.go-faster.co.uk

  7. Ping Chart www.go-faster.co.uk

  8. Example of Contention www.go-faster.co.uk

  9. The Database Test • Repeatedly queries same rows from • PTP_TABLE1_VW • PTP_TABLE1 • Poor test of database performance • Data blocks will become cached • %PerfTime = Application Server clock www.go-faster.co.uk

  10. The Application Server Test • Creates and copies row sets • Application server time = CPU time + DB time + Cache access time + Wait Time • Row set operations CPU intensive • Indication of CPU performance www.go-faster.co.uk

  11. Case1:Browser Time www.go-faster.co.uk

  12. Case 1: Desktop Specification • 384Mhz PC, 64Mb physical memory • Windows Commit Charge 125Mb • It’s paging memory to/from disk • With PS Ping running on PC, shut down everything else (virus checking etc). • Commit Charge reduced to 89Mb • Response time fell from 0.8s to 0.4s www.go-faster.co.uk

  13. Case 1: Conclusion • Paging memory from disk is slow • General Windows performance affected • Including the browser • Make sure that you have enough physical memory in your desktops • The web browser is a critical business platform • It’s not just for surfing www.go-faster.co.uk

  14. Case 2: Application Server CPU Benchmark? www.go-faster.co.uk

  15. HP-UX 11 750Mhz Ping Time: 1.43s [PT8.43.15] Windows 2000 3.2Ghz Ping Time: 0.33s Case 2: Two Application Servers www.go-faster.co.uk

  16. Case 2: Conclusion • Application server is CPU intensive • If active and not waiting for the database, it is using CPU to execute PeopleCode etc. • Fewer faster –v- More slower CPUs? • CPU speed is critical • When executing in user mode, a clock cycle is a clock cycle is a clock cycle? www.go-faster.co.uk

  17. Conclusion • Ping is not a fundamental indicator of system performance. • It does indicate: • contention in a particular tier. • CPU performance of Application Server • Performance of Browser www.go-faster.co.uk

  18. Questions www.go-faster.co.uk

  19. PeopleSoft Ping David Kurtz Go-Faster Consultancy Ltd. david.kurtz@go-faster.co.uk www.go-faster.co.uk

More Related