1 / 18

E166 Migration to and Scaling ASE 12.0

E166 Migration to and Scaling ASE 12.0. Joseph Buhl V-SPAN Software Joseph.buhl@vspan.com. MIGRATING TO & SCALING ASE 12.0. Topics Covered. Migrating From MSQL 6.5 to ASE 12.0 Scaling From 60 Concurrent Users to 160 Converting Oracle to Sybase

kyria
Download Presentation

E166 Migration to and Scaling ASE 12.0

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. E166 Migration to and Scaling ASE 12.0 Joseph Buhl • V-SPAN • Software • Joseph.buhl@vspan.com

  2. MIGRATING TO & SCALING ASE 12.0 Topics Covered. Migrating From MSQL 6.5 to ASE 12.0 Scaling From 60 Concurrent Users to 160 Converting Oracle to Sybase • Utilizing Enterprise Connect Data Access 12.0 Adding and Configuring Warm Standby With Replication Server

  3. MIGRATING TO & SCALING ASE 12.0 Initial Configuration and Environment MSSQL 6.5 • Minimal Stored Procedures and Triggers • 2 CPU, Windows NT 4.0 • 60 Concurrent Power Builder Thick Client Users • Minimal Web Access

  4. MIGRATING TO & SCALING ASE 12.0 Redundancy • Raid 5 • Nightly Backup and Log Shipping at 10 Minute Interval • Weekly Tape Backup Stored Off Site

  5. MIGRATING TO & SCALING ASE 12.0 Evaluation • Oracle? • MSSQL • Informix • Sybase

  6. MIGRATING TO & SCALING ASE 12.0 Feasibility Tests • ASE 12.0 on NT development • BCP Out of MSQL and Into ASE 12.0 • Utilized DB Artisan to Extract and Recreate All Database Objects • Installed Sybase open Client 12.0 on Power Builder Clients (developers)

  7. MIGRATING TO & SCALING ASE 12.0 Feasibility Tests • Converted Stored Procedures and Triggers to ASE Syntax • Installed Sybase open Client 12.0 on Power Builder Clients (developers) • Tested Power Builder Clients Against ASE 12.0 • Some Syntactical Differences in T-SQL

  8. MIGRATING TO & SCALING ASE 12.0 Production Setup • 2 Sun 420R, 2 CPU, Solaris 2.7 • ASE 12.0 • Redundancy • A1000 Storage array RAID 0+1 • Nightly backups With Log Shipping Utilizing Perl 5 DBI:DBD

  9. MIGRATING TO & SCALING ASE 12.0 Migration • Created Schema Objects from Development Scripts • Installed Sybase Open Client on All Client Machines • Redirected Power builder clients to ASE

  10. MIGRATING TO & SCALING ASE 12.0 Migration • BCP Data Out of MSSQL and Into ASE • Utilized BCP on NT to stage data • Grep data files for delimiters

  11. MIGRATING TO & SCALING ASE 12.0 Scaling • Peer Digital ,VSPAN Merger = 80 Instant Additional Users • Simple query tuning, Client Optimization • Added 2 additional CPU (9-11 spike) • Changed TCP no delay to true (power builder clients)

  12. MIGRATING TO & SCALING ASE 12.0 Scaling • Scan Desc, Open Objects, Open Indexes Adjusted Accordingly • Changed To Data Pages Locking on High Use Tables • Resized Procedure Cache

  13. MIGRATING TO & SCALING ASE 12.0 Converting Oracle To Sybase • Purchased Enterprise Connect • Enable CIS option in ASE 12.0 • Created and Configured Connections to Oracle

  14. MIGRATING TO & SCALING ASE 12.0 Converting Oracle To Sybase • Created Proxy Tables of Oracle Tables Inside Sybase • Performed Heterogeneous Joins for Analysis • Utilized PERL 5 DBI:DBD for Transformation and Load

  15. MIGRATING TO & SCALING ASE 12.0 Setting Up Warm Standby • Purchased Replication Server 12.1 • Installed replication server on 3rd Machine • Utilized rs_init to Add : • Logical Connection • Primary Connection • Standby Connection

  16. MIGRATING TO & SCALING ASE 12.0 Setting Up Warm Standby • Create Replication Definitions (recommended) • Employ Switch Active for Fail over • Monitor Queue and Transaction logs • Switching Clients • Open Switch

  17. S D E N T E R P R I S E 2 5 0 S D W t 1 1 2 5 S D t W 1 1 2 5 U L T R A S P A R C A L A R M 1 D R I V E N A L A R M 1 C e r t i f i e d E x c e l l e n c e S U P P L Y A S U P P L Y B S T E M C e r t i f i e d E x c e l l e n c e P O W E R S Y S T E M S u n m i c r o s y s t e m s S u n O N S T B Y m i c r o s y s t e m s O N S T B Y S D S D S u n S u n m i c r o s y s t e m s S t o r E D G E m i c r o s y s t e m s S t o r E D G E A 1 0 0 0 A 1 0 0 0 VSPAN WARM STANDBY TOPOLOGY S u n m i c r o s y s t e m s A L A R M 1 A L A R M 1 S U P P L Y A S U P P L Y B Replication Server P O W E R S Y Primary WarmStandby

  18. Color PaletteTitle can go to two lines Please choose from this color palette when highlighting text or graphics. Arrow Styles

More Related