VERITAS Database Edition for Sybase

1. VERITAS Database Editionfor Sybase Storage and Failover Management Software for Sybase Dataservers Melissa SteinProduct ManagementVERITAS Software April 1999 600-022200

2. Agenda • VERITAS Product Overview • DBA’s Challenges • VERITAS Database Editionfor Sybase • Enhanced Performance • High Availability • Improved Manageability • Summary

3. VERITAS Product Overview VERITAS Editions: well-integrated enterprise data management solutions VERITAS NetBackup: the high performance enterprise backup solution FirstWatch & VCS: the HA leader in the Sun market Volume Manager: the leader in on-line data management File System: the leader in on-line file system management

4. DBAs’ Priorities: Availability Recoverability Performance Manageability Database Administrators’ Challenges • Optimal database performance • 24x7 availability of mission-critical databases • Increasing management complexity • High growth in data volume • Complex data types (e.g., video, sound) • Increasing number of users • Diverse database server configurations (e.g. replication servers)

5. DBAs’ Priorities: Availability Recoverability Performance Manageability Database Edition for Sybase • VERITAS Database Edition for Sybase enables database administrators to manage Sybase ASE environments with the flexibility of file systems at raw disk performance. • Its data redundancy techniques and on-line administration features increase data integrity and availability. • The High Availability Edition adds monitoring and automatic recovery of Sybase databases to satisfy demanding 7x24 availability requirements. Database Edition for Sybase enables DBAs to meet their top priorities: optimal performance, data integrity, manageability, recoverability of databases, and database availability

6. Database Edition for Sybase File System Quick I/O Volume Manager VERITAS Database Editionfor Sybase Sybase Database Edition/HA FirstWatch or VCS Agent for Sybase File System Quick I/O Volume Manager

7. Performance Database Editionfor SybasePerformance • Raw disk performance • OLTP throughput for Database Edition equal to raw disk configurations • Achieves raw partition performance without sacrificing data integrity • Large I/O optimization • Accelerated I/O performance for large files (e.g., video, images) because of extent-based allocation • Database application-specific storage layouts • Striping and mirroring configurations for parallel data transfers • On-line performance tuning • I/O balancing and tuning without database downtime

8. Performance Quick I/O Sybase Server raw device regular file Raw Disk PerformanceQuick I/O Database Accelerator • Break-through VERITAS File System interface technology • Presents regular VERITAS File System files to Sybase as raw character devices (Sybase certified) • Allows parallel updates to database files for increased throughput • Takes advantage of kernel async I/O (Solaris’ KAIO) • Sybase handles locking for data integrity • Eliminates traditional UNIX file system overhead • Removes single-writer lock at file level • Bypasses redundant data buffering

9. Performance with Manageability Raw I/O Performance withEase of File System Management • Unique, total storage foundation solution to deliver the best of both worlds Database Editionfor Sybase Raw Disks Conventional File Systems Advantages Disadvantages Advantages Disadvantages • Performance • Lower database • throughput • (30-90% of • raw disk) • Higher CPU • overhead • Data IntegrityPotential data loss • Performance • Best OLTP performance • Data • Reliability • No potential for data loss with data written to • disks directly • Manageability • “Invisible” • locations for • segments • Difficult to • grow • segments • Manageability • Segment • organization • System-wide • backup and • restore • policies • Easy to create • and expand • files for Sybase

10. Performance Quick I/O PerformanceOLTP Benchmark Results • Quick I/O and raw disk I/O produce equal performance for OLTP benchmark • Derived from TPC-C • Mix of read-only and update-intensive transactions in order-entry environments • All configurations • include VERITAS • Volume Manager. • Test configuration • included: • Sun Ultra Enterprise • 4000 (4 CPUs; • 512 MG of RAM) • Solaris 2.5.1 • VERITAS Database • Edition 1.2 for Sybase • Sybase ASE 11.5.1 • TPC-0C scale factor • of 100

11. Availability The Need for High Availability • Many factors contribute to potential downtime • Software • Hardware • People • Planned downtime (for maintenance tasks) • Downtime impacts business operations • Revenue, productivity, and customer service at risk

12. Availability Brokerage Operations Finance $6.45 Million Credit Card/Sales Auth. Finance $2.6 Million Pay-per-View Media $150 Thousand Retail Home Shopping (TV) $113 Thousand Retail Catalog Sales $90 Thousand Transportation $89.5 Thousand Airline Reservations Media $69 Thousand Tele-Ticket Sales $28 Thousand Package Shipping Transporation Finance $14.5 Thousand ATM Fees Financial Impact of System Failure Application Industry Average Hourly Cost Source: Contingency Planning Research

13. Availability Database Editionfor SybaseAvailability • RAID redundancy techniques • Various storage configuration options to protect mission-critical data from disk failures • Hot relocation • Additional level of protection from disk failures • On-line administration • Storage reconfiguration and maintenance without downtime • Automatic monitoring and recovery of Sybase dataservers • Protection from system and application failures with Database Edition/HA for Sybase

14. Availability Database Edition/HA for Sybase • Integrates comprehensive fault management system • VERITAS FirstWatch or Cluster Server • VERITAS FirstWatch or VCS Agent for Sybase • Automatically detects and recovers from a system failure • Monitors and restarts Sybase instance after detecting Sybase dataserver failure

15. Manageability Database Editionfor SybaseManageability • Familiar file system administration for Sybase databases • Combines raw I/O performance and ease of file system management • Large database configuration support • Supports large file systems to simplify management • Simplified administration of physical storage configurations • Easy-to-use, JAVA-based graphical user interface • Various storage configuration layouts available • Quick, reliable deployment of High Availability services • Fully automated failover management

16. Manageability VERITAS Storage Administrator • Visual configuration management and performance analysis • Visual representation of physical to virtual relationships • Allows one-step graphical execution of common configuration management steps • Supports performance analysis and tuning

17. Manageability Database Administrator’s Guide • Cookbook for setting up and tuning database environments • Tailored for DBAs to optimize database storage layouts • Presents various storage configuration options • Recommends optimal configurations specific to database application workloads

18. Performance Availability Recoverability Manageability Database Edition for Sybase • Enhanced Performance • Raw disk performance with ease of file system management • Extent-based allocation • On-line performance monitoring and tuning • High Availability • Comprehensive fault monitoring and recovery • Increased data integrity and availability for mission-critical databases • On-line administration • Improved Management • Flexible storage configuration management • JAVA-based Storage Administrator

19. Performance Availability Recoverability Manageability Users Network End-User Applications Applications Disks Database Edition for Sybase VERITAS Database Edition for Sybase & HA Edition Storage Admin. FirstWatch or VCS+ Agents Sybase Server File System + Quick I/O Operating System VERITAS Volume Manager

20. Centralized Management High Availability  Scalable/High Performance Heterogeneous Integrated