Quest Solution for Application Performance Management

(1)

(2)

Quest Solution for

Application Performance Management

LooTong Tan

Principal Solutions Architect

Database Management Solutions Asia Pacific & Japan

陈鲁通

亚太区

(3)

(4)

4

Partnerships

Recognition

•Two-time winner, Microsoft Global ISV

Partner of the Year Award

•Microsoft Partner of the Year in Advanced

Infrastructure Solutions, Active Directory, 2009

•A leader in Gartner’s Magic Quadrant for Application Performance Monitoring1

If you would like to learn more about Quest’s position in the APM Magic Quadrant, you can download a complimentary copy of the report from our website at: www/quest.com/Gartner-Magic-Quadrant.

•#1 in Database Development and Management

Tools – replication segment, 2007 (IDC)

•#4 Worldwide and #2 in North America in Application

Management Marketplace Based on Total Software

Revenue for 20082

•#4 Worldwide and #1 in North America in Database

Management Software Marketplace Based on Total

Software Revenue for 20082

•#5 in the IT Management Software Market, 20093

(5)

(6)

6

The IT Management

Maturity Challenge

Source: “Application Management —

(7)

Application Performance Management

Maturity Stages

• No Tools • Adhoc • Manual Scripting

Stage1

Stage2

Stage3

• Monitoring Tools • Infrastructure Monitor • Point Monitoring • OLA

(8)

8 Network Gear Database Servers Application Servers Web Servers Domain Management

Quest Application Performance Management

Infrastructure Stage1 App 1 App 2 _ws _ws ws App 3 Infrastructure Management Applications_ManagementApplication

DatabaseDatabase Management Manual Stage2 Domain Mgmt OLA

(9)

“Every time we roll out a new app, we spend weeks on conference calls

pointing fingers at each other about all the problems.”

“We’ll only know people are having problems when someone calls the help desk.”

“How do we know the performance of the app will be as good as the developers promised?”

“The Help Desk struggles with new rollouts – they don’t even know

what to ask users when they report a problem.”

(10)

10

Application Performance Management

Stage 2

DB Monitor App Monitor Server Monitor Network Monitor End User Monitor Application Owner Network Team Sys Admin Team DBA Team End User

(11)

Application Performance Management

Maturity Stages

• No Tools • Adhoc • Manual Scripting

Stage1

Stage2

Stage3

• Monitoring Tools • Infrastructure Monitor • Point Monitoring • OLA • End-To-End • SLA / SLM • IT & Business Metric Linkage

(12)

12

Application Performance Management

Stage 3

App Performance Management DB / OS Management Virtualization Management SLA/SLM End-To-End & End User

Monitoring

End-To-End & End User

Monitoring

Application Management

Application

(13)

Quest Foglight for OS

• Broad support for most popular OS platforms

– AIX, Solaris, HPUX, Linux, Windows

• Deep coverage within each OS platform

– CPU, Mem, File System, Top Utilisation Process, NIC, Disk I/O etc.

• Minimum impact data collection

– low CPU utilisation, no data stored on monitored host, adjustable sampling frequency

• Easy deployment & maintenance

– management and configuration from central Foglight server

• Ease of Reporting

(14)

14

Foglight Application Performance Monitoring

Architecture

Web Servers

Application Servers

Databases

Experience Monitor & Viewer

Foglight Management Server Quest

Collectors

Foglight Synthetic Robots

(15)

(16)

16

(17)

Quest Foglight for Databases

• Support for most popular DB platforms

– Oracle, SQLServer, DB2, Sybase, MySQL

• Deep coverage within each DB platform

– Availability, Tablespace, Sessions, Top resource utilisation, SQL performance, DB logs etc.

• Lightweight data collection

– minimise impact on critical production DB

• Pre-emptive alerts

– warning on possible outage

• Configuration Advisories

(18)

18

Why Database Management is Crucial?

• Every Application System has a Database

• Unless in clustered and isolated transaction environment,

even clustered application accesses a common data

source (single point of performance problems)

• Application can scale quite linearly whereas Database &

SQL normally scale exponentially

• Application code’s problems once fix will not return but

same tuned SQL might function differently with different

volume of data

• More developers knows how to write good application

code than developers who knows how to write good SQL

• Bad Database Performance affect ALL apps running on

that Database, Bad Code might only affect certain

(19)

(20)

(21)

(22)

(23)

Quest Foglight Application Management

• Supports packaged & custom apps

– WebSphere, WebLogic, Oracle App Server, .NET etc. – SAP, Siebel, PeopleSoft, Oracle EBiz etc.

• Insight into program execution

– breakdown of code execution in Java and .NET, internal processing details within application servers

• Efficient deployment

– no code change needed, configuration only

• Short time-to-value

(24)

(25)

(26)

27

(27)

(28)

(29)

(30)

(31)

(32)

(33)

What is End-To-End?

• Almost every vendor claims they can do End-to-End

monitoring

• What is actually End-To-End?

• Server-To-Server?

• The End-User’s Experience is the most important

Application Server Web Server

Tier

Database Server Tier

(34)

35

Common Business Use Case

• Lack of visibility of End User Profile

– Is my business-critical website optimized in terms of design? • Where are my users geographically located?

• What ISP are my users connected to? • What access speeds do my users have?

• What browsers are majority of my users using?

• Lack of visibility of End User Usage Patterns

– How many users are accessing my business-critical web sites?

– How long do they spend on each page? – Which page do they visit most frequently?

(35)

Common Business Use Case

• Lack of visibility of End User Experience

– User-Priority:

• Which end users are being impacted? • Are my priority users being impacted? – Business-Priority:

• Which business transactions are slow across all end users?

• Business Analytics

– How much $ is being generated from the site? – How much potential revenue is lost?

– How many times a specific business transaction is performed every hour?

(36)

37

Common Technical Use Case

• What is causing End User Experience Issues?

E.g. Slow Response Times, less user visits, less

stickiness

– Client-Side Issue

• Is it due to unsupported browser? • Is it due to slow access speeds? – Network Issue

• Is it due to outage with the ISP/subnet that my users are connected to?

– Backend Application Infrastructure Issue

• Is it due to outages in the application infrastructure (i.e. Apps Server, Database Server?

• Is it due to longstanding Infrastructure capacity issues that has been unattended and thus affecting more and more users to stop visiting altogether? Infrastructure issue

(37)

Common Technical Use Case

• What Infra Issue is causing particular business

transactions to be slow?

– This ties back to the Foglight JavaEE/.NET and Database pieces, where we can perform deep-diagnostics to

understand the root cause

• What Infra-related Issue is causing business

transaction to fail?

– HTTP-level errors (e.g. HTTP Status Code 404 / 500) – Application-wrapped errors (e.g. SQLException)

(38)

39

Quest End User Management

Quest’s End User Management solution

provides

transaction simulation

,

performance measurement

and

problem

reproduction

to guarantee optimal service

levels for your applications by assigning

accountability for the end user experience.

(39)

(40)

41 Discovery

Able to help Tier1 Support Identified whether problem is with Network or with Back-End Systems. Response Time suddenly shot up to > 10 seconds

(41)

Understanding End User Profile…

Access speeds that users have…

(42)

43

Understand your user demographics…

And where users are coming from…

(43)

Gain visibility into the end-to-end application

transaction response times of users from different

(44)

45

Drill down into a specific application transaction to understand the end-to-end response times profile as

experienced by real users, not synthetic users!

(45)

Determining the download times

associated with the various content types

(e.g. java scripts, flash, etc) used in your application web pages…

Provides insights as to how content types should be optimally used to enhance the end user experience…

(46)

47

Drill-down into all the components of a specific content type for greater in-depth resolution…

(47)

Part 2:

Business/Application Transaction

Performance Stats

(48)

49

Top 3 slowest application/ business transactions

(49)

Drilling into Individual User Session Details

Understand the profile of this specific user and the end-to-end response times

(50)

51

…and the response time of each

transaction step that he clicked through. Product Lookup

(51)

(52)

(53)

(54)

(55)

Until Page with Error

that End-User saw

(56)

57

(57)

(58)

59

% of SIM Card

Activations that

falls within the SLA

(59)

Business Analytics View

Business Intelligence:

(60)

61 Network Gear Database Servers Application Servers Web Servers Domain Management

Quest Application Performance Management

Infrastructure Stage1 App 1 App 2 _ws _ws ws App 3 Infrastructure Management Applications_ManagementApplication

DatabaseDatabase Management Manual Stage2 Domain Mgmt Stage3 App+Svc Mgmt End Users End User Management ws ws ws ws WS Svc1 Svc2 Service Level Management Biz Metrics Business Service Metrics Discovery Diagnose Resolve MTTR Biz Owners OLA