Transcript Teleran_XWeek_Presentation

Sell more Exadata
Reduce Exadata
sales cycle
Improve competitive
position
Helping Exadata Sales
Kevin Courtney, Vice President, Marketing
Agenda
•
Benefits to Oracle
•
Challenges from the Field
•
The Teleran Solution
•
Q&A
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Why Are We Here?
Question #1
Why attend this Teleran presentation?
A.
Understand the meaning of life
B.
Free drinks at local pub
C.
Solutions to assist in Exadata Pre and
Post Sales
D.
Earn an On-line degree
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Benefits to Oracle Exadata Sales
•
Sell more Exadata (enterprise solution)
•
Reduce Exadata sales cycle
•
Move stalled deals forward; Speed time to
value
•
Improve competitive position
Aligns to business value; Reduces time-to-close; Reduces project risk / cost /
duration; Improves POV results
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Benefits to Exadata Sales - How
•
•
•
•
Improve visibility into customer
environment
Speed up migrations / consolidations
Identify pre and post sales application
tuning
Link to business use
Addresses sales objections; Reduces time-to-close; Reduces project risk
/ cost / duration; Improves POV results
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Exadata Usage Assessment
•
Post Excite process; Speed up sales cycle
•
Uses Teleran’s patented automated data collection
usage tracking software and services
•
Delivers comprehensive, factual analysis, findings
and recommendations, not anecdotal observations
Reinforces findings of Excite process; Provides detailed deployment
roadmap; Reduces risk / cost / duration
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Challenge: Slow Consolidations/Migrations
•
Moving 50 DB, Marts, ODS’ & OLTP’s onto
Exadata
•
Oracle & SQL Server (several versions)
•
24 x 7; global operations
•
Some applications are in poor health
Monitor and develop work profiles, identify remediation, project plan for
success, prepare for next round of Exadata sales
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Challenge: Proving Exadata Benefits
•
Highly-tuned DB2 and Oracle warehouses
•
Home-grown BI; Business Objects; OBIEE
•
Need to validate Exadata improvements
•
Identify and benchmark key queries; indices
Pareto 80/20 analysis, Bind Variables analysis, benchmark,
validate, reduce time and cost
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Challenge: Ensuring Successful POVs
•
Benchmark on “Retail 57” at Oracle Solutions
Center
•
Provide visibility and metrics into query behavior
•
Provide insight into tuning to improve performance
•
Provide POV candidate queries based upon profile
Use Teleran prior to POV to provide insight into environment for Exadata
best-foot-forward
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Challenge: Aligning to Business
•
Adds business context (LOB, Dep’t, Geography)
linking application and data usage to the business
•
Provides visibility: Users, Applications, DB
Objects, Data
•
Focuses Exadata deployment on key business
benefits
Link Exadata to business use and value
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Challenge: Un-Authorized Datamarts
•
Identified several (7) datamarts; avg. 450 GB,
max 7TB
•
Resources wasted: MS Access; Toad
•
Resources wasted: Overall throughput, Missed
SLAs
•
Compliance and security violations
Use Teleran prior to POV to provide insight into environment for Exadata
best-foot-forward
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Challenge: Exadata Slowdown
•
Exadata performance slowing down
•
Identified poorly coded home-grown application
•
Database connections left open; resources
exhausted
•
Teleran identify open connections symptoms;
problem solved
Use Teleran post POV on ongoing basis to provide continuing insight into
Exadata usage
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Challenge: Un-Healthy Source Systems
•
DB2 EDW; Oracle ODS with ‘000’s users via Web
•
Too many db errors; deadlocks in real-time ETL
•
DB tuning highly over budget & behind schedule
•
New CEO & VP IT
Some applications need to be remediated before moving.
“Fork lifting” does not always work.
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Why Teleran?
Question # 2
How Can Teleran Help?
A.
Provide deep visibility into overall usage
patterns
B.
Identify critical queries for effective POVs
C.
Identify un-healthy conditions needing
remediation
D.
Reduce the risk, cost and time to value
E.
All of the above
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Teleran’s Mission
Helping IT gain an understanding and
manage data-intensive applications
•
Software and services company
•
Fourth generation product – eight patents
•
Oracle partner 10 years
•
Certified on11g Exadata at Oracle Solutions
Center
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Selected Teleran Customers by Industry
Healthcare
Pharmaceutical
Insurance
Financial Services
Banking
Government
Other
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
New Jersey Medicaid
Managing Dynamic Applications
Risks
• Dynamic
• Less Controlled
• Unidentified
 Performance Issues
 No Visibility into End-User/Business
 Rising System & Support Costs
Users
• Complexity
• Mixed Workloads
• Multi-Tenancy
Data
• Inefficient SQL
• Resource Intensity
• Rogue Users/Transactions
Applications
Data
Requests
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
• Ad Hoc Tools
• Unpredictable Use
• Customer Driven
The Teleran Solution
Track  Analyze  Control
iSight™- Tracks activity across four dimensions
• User, Application, Query and Data
• Maintains persistent identity of users and organizational context
• Integrates BI and other application level metrics
iSight Analytics - Analysis, Insight and Decision-Making
• Dashboards and analyses deliver deep insight on app performance,
resource efficiency, user behavior, and business context
iGuard™- Policy Engine Controls Queries, Guides Users
• Intelligently filters poorly formed, inappropriate queries
• Guides users with messages; Sends alerts to IT
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
iSight Analytics
Analyzes summary and detailed user activity
within organizational context
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
iSight Analytics
Analyzes poorly structured queries,
identifying remediation
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
iSight Analytics
Analyzes query response time by named
business users
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Solution Architecture
Users & Applications
Users & Applications
Oracle Databases
Teleran Listener
Usage
Logging
Business Context
Exadata
Analysis &
Reporting
iSight Analytics
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Teleran
Repository
Teleran and OEM
Teleran
OEM
Targeted Roles
Business Stakeholders, Analysts, Application Mgrs, DW
Mgrs, Information Managers, Architects
IT Managers, DBA Managers, DBAs,
System Administrators
Product Purpose
• App usage / adoption
• DW growth and budgeting Identify app modifications
• User training needs
• Dormant data / ILM
• Tune BI semantic layers Adjust data models
• SQL performance tuning.
• System level database admin and
optimization
• Java EE/SOA performance mgmt.
• http/Web app clickstream analysis
Metrics Captured
• Business context (Geography, Dept., Function, Role)
• User identities (LDAP, App, OS and DB user IDs).
• Application report name, semantic layer,
• Parsed queries,
• Database objects accessed
Database system level (CPU, IO, wait
stats, long running SQL and other system
level metrics)
Capture Method
Continuous real-time capture on the network
Periodic snapshot in the database
Query Detail
Every query 24x7
Long running queries above threshold,
aggregated by snapshot time period
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
When to call Teleran?
Question # 3
When Can Teleran Assist?
A.
Speeding up migrations / consolidations
(time to value)
B.
Provide visibility into current usage to
ensure Exadata success
C.
Identify critical usage for tuning
D.
All of the above
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.
Who to Call?
Kevin Courtney, VP Business Solutions
Phone
E-mail
(973) 439-1820, ext. 214
[email protected]
Teleran Support Website for Oracle
www.Teleran.com/oraclesales
Password: sellexadata
The Teleran logo, iSight and iGuard are trademarks or registered trademarks of Teleran Technologies,
Inc. Other brand and product names are the marks of their respective owners. SO3.15.11
Copyright © 2011 Teleran Technologies, Inc. All rights reserved.