Symantec Indepth for Sybase

1. Symantec Indepth for Sybase Application Performance Management

2. AGENDA The APM Opportunity with Sybase The Customer Pain Solution: Symantec Indepth for Sybase Competitive Landscape 1 2 3 4

3. The APM Opportunity with Sybase • Provide Additional Value-Add to Current APM Customers Needing a Sybase Performance Tool • New Addressable Market for Symantec APM Solutions • More than 1700 of the world’s largest financial institutions1 • 90% of the world’s securities firms1 • 60% of the world’s banks1 • 3.1% Market Share of Worldwide RDBMS Revenue2 • Sybase is the #4 player behind Oracle, IBM, & Microsoft2 www.sybase.com1 IDC# 329292

4. How is a Sybase Database Used? • Contains tables populated with large amounts of data • Allows access to the data via Structured Query Language (SQL) • Controls the organization, access, integrity and security of the data Sybase The DB accepts requests for data from the application program and instructs the operating system to transfer the appropriate data.

5. AGENDA The APM Opportunity with Sybase The Customer Pain Solution: Symantec Indepth for Sybase Competitive Landscape 1 2 3 4

6. When performance suffers, who is blamed? • 80% of Performance Issues Are the Result of Poor Application and DB Design • “Blamestorming” causes the DBA/database to be blamed for all performance problems “Blame-O-Meter”

7. Remain the same Earnings and Per Unit Profitability Expenses and Cost of Goods / Services Customer Satisfaction and Service Levels Cycle Times and Employee / Partner / Customer Productivity Success rate of Mergers and Acquisitions Today Tomorrow Corporate Objectives The Pressure’s On…. Greater web dependency faster time to market Increased business efficiency More/new competitors Intensified business complexities Market consolidation Company valuation pressure Evolving internet paradigm

8. What The CIO Sees • Increasing Pressure On Service Levels… • Deployment Of Web Based Applications • Complex Environment • Decreasing IT Budgets Require… • More Efficient Use Of Storage Hardware • More Efficient Use Of Server Hardware • More Productive IT Staff ……… • DO MORE WITH LESS….

9. Feeling the PAIN • The Executive wants visibility into service level delivery. • The IT Manager wants end user complaints about application performance to go away. • The Dev Manager wants to optimize applications for performance quickly. • The DBA wants to find problems before they occur, get more data to resolve issues quickly, & prove the availability of the database over time.

10. Feeling the PAIN • The DB Developer wants to understand the impact of the application on the database. • The App Architect wants to ensure that improper capacity planning is a worry of the past. • The QA Manager wants to get the application to production on time.

11. ….Flying Blind is Not an Option…. Track and manage your mission critical applications

12. Visibility is Needed at All Levels of the Company • What is happening now? • What happened at 3:00 AM yesterday? • Who is consuming resources and why? • What was resource consumption in January vs. February? • How much will I consume next month? • Am I meeting business objectives now? Next month? Next year? • How can I find the root cause of a performance problem faster and then fix it?

13. Storage Area Network (SAN) Logical Volume I/O Channel Physical Device Network Attached Storage (NAS) Logical Volume I/O Channel Physical Device Multi-Tier Transaction Path Complexity Sybase Server J2EE Application Server Web Server SQL Statement Index Java Server Page Batch Programs HTTP Enterprise Java Bean Table Space Full Table Scan URL OS Metrics Table Column JPEG Web Browser Invocations Users Locking OS Metrics Servlet Servers Instances JSP SQL Statement I/O OS Metrics Java DB Connectivity

14. AGENDA The APM Opportunity with Sybase The Customer Pain Solution: Symantec Indepth for Sybase Competitive Landscape 1 2 3 4

15. What is Symantec Indepth for Sybase? • Symantec Indepth for Sybase . . . is an enterprise software solution that monitors, tunes, and analyzes Sybase databases to correct the root-cause of database performance bottlenecks before affecting the end-user.

16. Monitor Store Retrieve, and Analyze View and Manage Symantec Indepth for Sybase Architecture IIS Web Servers J2EE App Server Web Clients Internet Sybase i3 Performance Warehouse i3 Focal Point Web GUI

17. Symantec Indepth for Sybase Features

18. Compare Different Instances 18

19. Symantec Indepth for Sybase Features

20. Monitor Space Utilization of Sybase Objects 20

21. Symantec Indepth for Sybase Features

22. Understand Database Performance Over Time 22

23. Symantec Indepth for Sybase Features

24. Tree View of SQL Plan The execution plan is displayed in a tree format - easy to read 24

25. Symantec Indepth for Sybase Features

26. Display Statement information as related Batches

27. AGENDA The APM Opportunity with Sybase The Customer Pain Solution: Symantec Indepth for Sybase Competitive Landscape 1 2 3 4

28. Weaknesses No multi-instance comparison Several different applications with different collectors ( up to 5 collectors on a single tier) Requires large amount of disk space ( up to 6 separate data repositories needed) No correlation of live transactions across tiers Strengths Attractive GUIs, but different each application Strength in DB management space (e.g., Toad) and existing relations with DBAs Competing with Quest • QUEST Central For Sybase • SPOTLIGHT for SYBASE ASE • Integration with Other Spotlight Consoles (Oracle, SQL,Unix, Etc) • Integration with Foglight • QUEST SQL TUNING (Previously LECCO Technology) • SQL Capture (SQL InSpector) • SQL Optimization (Alternate SQL) • Index Recommendation • Impact Analysis (Indexes, Parameters, Migrations) • Loose Sybase Relationship around previous LECCO Relationship

29. & QUESTIONS ANSWERS

30. Thank You!