Jerry Held

1
(No Transcript)
2
The New Enterprise Manager End to End
Performance Management of Oracle Solutions
Session id 40031

• Julie WongPrincipal Product Manager
• Arsalan Farooq
• Senior Development Manager
• Oracle Corporation

3
Agenda

• Challenges of managing application performance
• Application Performance Management Methodology
• Availability management
• Performance management
• Root cause analysis
• Managing the complete Oracle Eco-system
• Oracle Enterprise Manager 10g - Application
  Performance Management Demonstration

4
Web-Based Business Applications

• Integral part of business world
• Need to service increasingly demanding users
• Doing more - faster, remotely, accurately
• Rapidly raising productivity levels

NYC
London
Sydney
5
Challenges of Managing Web Applications

• Complexity of applications
• Heterogeneous and distributed systems
• Expensive and time consuming to manage
• Need to minimize impact of problems on end-users
• Understanding business impact of problems
• High cost of downtime and poor performance
• Inefficient and slow problem resolution
• Disparate management solutions
• Complex diagnostic tools

6
Managing Application Performance Problems

• Who is the problem impacting?
• What is the business impact?
• Where in the infrastructure is the problem?
• Whose problem is it?
• Why is the problem occurring?

Internet
Application Developer
System Administrator
Data Center Support
DBA
Network Service Provider
7
What is Oracle Enterprise Manager 10g Application
Performance Management?

• New functionality for ensuring high availability
  and performance for Web-based applications
• Enhances our systems management solution to
  provide the richest monitoring of the Oracle
  platform available

Oracle Enterprise Manager 10g
Application Performance Management
Oracle Eco-System
8
Application Performance Management Methodology
Detect
Monitor
Resolve
Isolate
9

Application Performance Management
Oracle Enterprise Manager 10g
Application Performance Management
Availability Management
Transaction Performance
Page Performance
Cross-Tier Tracing
SLA Management
Alerts
Trending
Root Cause Analysis
Notifications
Modeling End-User Communities
Impact Analysis
Oracle Eco-System
Non-Oracle Systems
10
Web Application Availability

Viewing Stock Quotes
Placing Bid
Purchasing Book
Can users complete critical transactions
successfully? Is the business application
available to all users at all times?
11
Application Availability Management

• Define availability criteria for your Web
  application
• Monitor critical components and functional paths
• Model user communities across your infrastructure
  
• Out-of-the-box application component monitoring
• Ensure availability of URLs and network
  components

internet
Web Application
12
Model End-User Communities
Web Application
Performance may vary from location to location
13
Database, Middle Tier Availability

• Integration with Enterprise Manager 10g framework
  provides availability monitoring of Oracle
  Eco-System and non-Oracle components

14
Network Component Availability

• On-demand network component and URL testing
• Network and URL Watch Lists
• Network Response
• HTTP Response
• Network route trace

15
Availability Monitoring Topology
Apps and Mid-Tier Servers
End Users
Database
Hosts
Storage
Network
Beacon running availability transaction
Beacon running availability transaction
Beacon running availability transaction
Oracle9iAS
Oracle Database
Beacon running availability transaction
3rd Party App Server
16
Performance Management Approach

• Transaction based
• Business-centric monitoring
• Pre-empt problems with proactive monitoring
• Model user communities across infrastructure
• Monitor real end-user experience
• Performance trending

17
Business Transaction Monitoring

• Monitor critical online business processes
• Scope and quantify impact of performance problems
  on all user communities
• Isolate network vs server related delays
• Transaction profiling
• Alerts and notifications

internet
Web Application
18
Transaction Monitoring Recorder

• Rapid deployment and immediate value
• Simple, automatic, no scripting
• Beacons automatically synchronized to play
  transactions at specific intervals

Start recorder which opens new browser window
Enter URL and navigate through transaction
Save Transaction
1
2
3
4
19
Performance Monitoring Topology
Apps and Mid-Tier Servers
End Users
Database
Hosts
Storage
Network
Oracle E-Bus Suite
Oracle9iAS
Beacon running representative transaction
Oracle9iAS
Oracle Database
Oracle9i Database
Beacon running representative transaction
3rd Party App Server
20
End- User Performance

• Monitoring of ALL URLs accessed
• End-user impact analysis
• Server vs network response time
• Analysis of end-user response times by URL,
  domain, regions, visitor, Web server
• Watch list to highlight performance of critical
  URLs

Web Application
21
Root Cause Analysis

• Direct administrators to root of problem
• Interactive, in-depth transaction tracing
• Middle tier page performance analysis
• Application performance correlation

22
Interactive Cross-Tier Transaction Tracing

• Diagnose problems across all tiers of J2EE Web
  application
• Intuitive drill-downs of all invocation paths to
  the SQL level

URL/JSP
EJB
JDBC/SQL
internet
Middle Tier
23
Middle Tier Page Performance Analysis

• Application server and back-end problem
  diagnostics
• Middle tier processing time and load breakouts
• Detailed URL processing call stack tracing
• Slowest URLs and number of hits
• Top servlets / JSPs by requests /processing time
• Tuning recommendations

24
Page Performance Analysis

• Full URL processing call stack analysis
• Middle tier processing time and load breakouts
• Tracing down to the SQL statement level

Servlet
EJB
JSP
JDBC
internet
Middle Tier
25
Application Performance Correlation

• Determine how each application component affected
  overall performance
• Correlate
• Component resource utilization
• - CPU utilization, memory and I/O usage
• Component load and response times
• Component availability
• - Database, HTTP server, Hosts, OC4J, Web Cache
• Individual component metrics

26
Application Performance Management
Click-to-SQL Drilldowns
Click-to-EJB and J2EE Activity
New York Sales Office

• Monitor key business transactions
• Availability
• Performance

Web Application
Paris Sales Office
Tokyo Sales Office
External network
Internal network
Application Content
App Server
Database
Any Application User
End to End Tracing
End-User Performance
27
End-to-End Performance Management
Database
Oracle Application Server
Host and Hardware
Performance Management Administration Diagnostics
Configuration
Network and Load Balancer
Applications
Enterprise Manager
Storage
28
Managing the Oracle Eco-System
End Users
Oracle Collab Suite
Oracle eBus Suite
Integrated Management of Oracle Products
3
Oracle Database
29
Application Performance Management Key
Differentiators

• Only enterprise software vendor to provide an
  application management solution that is
• Scalable
• Manage 1000s of systems with minimal incremental
  cost
• Complete
• One end-to-end monitoring solution for all Oracle
  products
• Integrated
• Administration, end-user and system diagnostics,
  tuning, software/hardware configuration, etc from
  a single console
• Low cost to implement
• Pre-configured and ready to use

30
D E M O N S T R A T I O N
Oracle Enterprise Manager 10g Application
Performance Management
31
A
32
Reminder please complete the OracleWorld
online session surveyThank you.
33
(No Transcript)