PEOPLESOFT PERFORMANCE MONITORING AND OPTIMIZATION Enduser measurement combined
PEOPLESOFT PERFORMANCE MONITORING AND OPTIMIZATION End-user measurement combined with deep technical visibility © 2016 IDERA, Inc. All rights reserved. Proprietary and confidential.
BETTER VISIBILITY, BETTER OUTCOMES. . . This is Precise's value proposition… © 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 2
ONE APPLICATION | SIX TECHNOLOGIES NUMEROUS END-USERS Browser Network Web Server End-User access a People. Soft panel in a browser from their workstation. Graphics, scripts, result sets all have to traverse the network to reach the end-user. Receives and sends all interactions with the end-user. Java Jolt/Application Tuxedo Business logic with capability to build SQL statements. This is the glue that holds the People. Soft together. Oracle / Storage Every significant transaction interacts with the database. © 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 3
DAY IN THE LIFE. . . § How to help the end-user? © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential. 4
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 5
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 6
PRECISE ARCHITECTURE FOR ORACLE & DB 2 Performance Portal DBA Developers & Storage Admins P-W Weblogic P-J Java Jolt P-T Tuxedo Precise Server PMDB Oracle VM P-O Oracle
Effective Communication Transaction Performance Alerting Client Network Web Srvrs App Srvrs DB Srvrs Storage Portal Root Cause Analysis to solve the problem © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential. 8
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 9
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 10
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 11
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 12
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 13
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 14
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 15
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 16
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 17
Quote One “ Before Precise, our DBAs were using OEM and tuning the top ten SQL statements. At the Oracle instance level, things appeared to be OK. Precise, by pinpointing the SQL statement that a People. Soft panel relies, our DBAs were able to squeeze additional performance out of Oracle. . © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential. 18
Quote Two “ Precise’s ability to translate URL’s into panel names allows us to talk the same language as our users. Precise’s ability to capture the People. Soft user ID is the reason that we rely on Precise. © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential. 19
EXPLAIN HOW PRECISE CAPTURES THE PEOPLESOFT USER ID AGAIN § We have load balancers and reverse proxy © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential. 20
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 21
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 22
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 23
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 24
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 25
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 26
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 27
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 28
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 29
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 30
§ WHAT IS HAPPENING AT THE SERVER? § Precise provides a Physical, Virtual, and Host history § OS is captured in real time © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential. 31
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 32
§ ALERTING! § I don’t have time to watch everything § However, I need to know when there is a problem developing © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential. 33
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 34
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 35
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 36
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 37
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 38
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 39
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 40
§ TUXEDO, IS IT A PROBLEM? § I don’t have time to watch everything § However, I need to know when there is a problem developing © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential. 41
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 42
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 43
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 44
§ JAVA JOLT § Jolt is the bridge between People. Soft the web server and the application server § All end-user traffic traverses Java Jolt © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential. 45
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 46
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 47
EVERY SIGNIFICANT BUSINESS TRANSACTION INTERACTS WITH THE DATABASE § Transaction performance starts with SQL statement execution time § A new perspective; a second opinion © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential. 48
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 49
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 50
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 51
© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 52
PRECISE APPLICATION PERFORMANCE PLATFORM Better visibility; better outcomes… © 2016 IDERA, Inc. All rights reserved. Proprietary and confidential. 53
- Slides: 53