1 / 15

Enhancing Sybase Database Performance and Management with VERITAS Database Edition

The VERITAS Database Edition for Sybase addresses the critical needs of DBAs facing immense time pressure and the challenges of managing increasing data volumes. It ensures continuous availability of mission-critical databases with rapid data access and robust management capabilities. This solution integrates advanced features such as raw device performance, file system manageability, and high availability monitoring. With a Java-based GUI for seamless configuration and improved OLTP performance, it allows businesses to manage Sybase databases efficiently while ensuring data integrity and operational continuity.

adila
Télécharger la présentation

Enhancing Sybase Database Performance and Management with VERITAS Database Edition

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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. VCS Agent for Oracle VERITAS Solution:Database 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 Editionfor Sybase Raw Disks Conventional File Systems Advantages Disadvantages 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 raw device regular file 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 • 1:1, Any:1 and 1:Any 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!

More Related