Transcript VERITAS Software Investor Update

Database Edition
for Sybase
Sales Presentation
Market Drivers
• DBAs are facing immense time pressure
in an environment with ever-increasing
data
• Continuous availability (24x7) of missioncritical Sybase databases
– Faster access to data – Performance!!
– Easier management of increasing data
– Data integrity – High availability
VERITAS Solution:
Database Edition for Sybase
Sybase
Database Edition for Oracle
VCS
Agent for Oracle
Volume Manager Storage Administrator
Building
Blocks
VERITAS File System with (Cached) Quick I/O
VERITAS Volume Manager
HA Edition
Product Positioning
VERITAS Database Edition for Sybase
offers raw device performance with file
system manageability.
• Offers equal to raw performance and for highmemory systems even greater performance
• Offers ease of management of file systems
• Increases availability of Sybase dataservers
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
Raw I/O Performance with
Ease 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
Advantages Disadvantages
Performance Manageability

Best OLTP
performance
Data
Reliability

No potential
for data loss
with data
written to
disks directly
“Invisible”
locations for
segments
 Difficult to
grow
segments

Advantages Disadvantages
Manageability



Segment
organization
System-wide
backup and
restore
policies
Easy to create
and add
devices
for Sybase
Performance


Lower database
throughput
(30-90% of
raw disk)
Higher CPU
overhead
Data Integrity
Potential
data loss
Quick I/O for Databases
Breakthrough VERITAS File System interface technology
Presents regular VERITAS File System files to Oracle as
raw character devices
Quick I/O
regular raw
file device
RDBMS
Server
• 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
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 updateintensive transactions in order-entry environments
Online Transaction Processing Throughput
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
1600
Transactions per Minute
All configurations
include VERITAS
Volume Manager.
1400
1200
1000
Sybase Edition
800
VxFS Direct I/O
600
Raw Partitions
400
200
0
100MB
200MB
300MB
Sybase Disk Buffer Cache
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-tomemory 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
VERITAS Storage Administrator
Simplifies Management
• Allows one-step graphical execution of common
configuration management steps
Database Edition/HA
VERITAS Cluster Server
Sophisticated availability
configuration management
Clustered HA solution
allowing 2-32 server
scalability
1:1, Any:1 and 1:Any policybased 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
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
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
Summary
Database Edition for Sybase enables
businesses to meet their top database
priorities:
• Optimal performance
• Manageability
• High data and database availability
Business without interruption.
Thank you!