Database Edition for Sybase

1
Database Edition for Sybase

• Sales Presentation

2
Market Drivers

• DBAs are facing immense time pressure in an
  environment with ever-increasing data
• Continuous availability (24x7) of
  mission-critical Sybase databases
• Faster access to data Performance!!
• Easier management of increasing data
• Data integrity High availability

3
VERITAS SolutionDatabase Edition for Sybase
Sybase

Database Edition for Oracle
HA Edition
Building Blocks
Volume Manager Storage Administrator
VERITAS File System with (Cached) Quick I/O
VERITAS Volume Manager
4
Product Positioning

• VERITAS Database Edition for Sybase offers raw
  device performance with file system
  manageability.
• Offers equal to raw performance and for
  high-memory systems even greater performance
• Offers ease of management of file systems
• Increases availability of Sybase dataservers

5
Key Features

• VxFS with Quick I/O delivers raw disk performance
  and ease of file system administration
• Equal or better OLTP throughput
• Ease-of-use is provided with a Java-based Storage
  Administrator GUI
• Visual configuration from a single console
• HA Edition provides automatic monitoring and
  recovery of Sybase application

6
Raw I/O Performance withEase of File System
Management

• Unique, total storage foundation solution to
  deliver the best of both worlds

Database Edition for Sybase
Raw Disks
Conventional File Systems
Disadvantages
Advantages
Advantages
Disadvantages

• Manageability
• Invisible
• locations for
• segments
• Difficult to
• grow
• segments

• Performance
• Lower database
• throughput
• (30-90 of
• raw disk)
• Higher CPU
• overhead
• Data IntegrityPotential
• data loss

• Manageability
• Segment
• organization
• System-wide
• backup and
• restore
• policies
• Easy to create
• and add devicesfor Sybase

• Performance
• Best OLTP
• performance
• Data
• Reliability
• No potential
• for data loss
• with data
• written to
• disks directly

7
Quick I/O for Databases

• Breakthrough VERITAS File System interface
  technology
• Presents regular VERITAS File System files to
  Oracle as raw character devices
• 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

RDBMS Server
8
OLTP 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

9
Cached Quick I/O Overview

• Implemented as a buffered read, direct write
  solution
• Retains data reliability advantage of direct
  write
• Gains read-ahead at the File System and
  memory-to-memory copy performance advantage
• Easy online management to turn Cache on/off for
  Quick I/O files
• Like Quick I/O, enabled on a per-file basis
• Multiple database instances can co-exist with
  selective caching for specific datafiles

10
VERITAS Storage Administrator

• Simplifies Management
• Allows one-step graphical execution of common
  configuration management steps

11
Database Edition/HAVERITAS Cluster Server

• Sophisticated availability configuration
  management
• Clustered HA solution allowing 2-32 server
  scalability
• 11, Any1 and 1Any policy-based failover
• Application level cascading failover
• Fast Kernel-to-Kernel communication failover
• Certified 3rd party support for SCSI, SAN NAS
  storage
• Centralized Cluster Manager console for HP-UX,
  Solaris and Windows NT

12
Key Selling Points

• Performance
• Database Edition Performance achieves at least
  equal to Raw Device Performance
• OLTP benchmark results (TPC-C derived)
• Manageability
• Even new DBAs can manage Sybase with when the
  Edition is installed
• High Availability
• Applications keep running when servers fail

13
Supported Platforms

• Solaris 2.6, 7, 8
• Sybase Adaptive Server Enterprise 11.5.2, 11.9.2,
  11.9.3, and 12.0
• SYBASE CERTIFIED

14
Summary

• Database Edition for Sybase enables businesses to
  meet their top database priorities
• Optimal performance
• Manageability
• High data and database availability

15
Business without interruption.
Thank you!