SYBASE DBA Migrating to Sybase System 11 5

SYBASE DBA Migrating to Sybase System 11. 5 & the Maintenance of CDR Brian Ramey 1/9/98 1998 Client Server Team Presentation: Sybase DBA 1

What You Will Learn l System 11. 5. Why and How we migrated? l CDR, behind the scenes. l Every question I’ll ask will have the same answer, “Better Performance”. l Brian’s addition to sign language. 1/9/98 1998 Client Server Team Presentation: Sybase DBA 2

Why we Migrated to System 11. 5 1/9/98 1998 Client Server Team Presentation: Sybase DBA 3

Why we Migrated to System 11. 5 l Better Performance. – More Parallelism – Better Memory Management 1/9/98 1998 Client Server Team Presentation: Sybase DBA 4

Why we Migrated to System 11. 5 l Easier Maintenance. – DDL objects are created faster – New dbcc command – Sybase will soon not support previous versions – Sysaudits without the wait (coming soon) 1/9/98 1998 Client Server Team Presentation: Sybase DBA 5

How we migrated to System 11. 5 l Goals: – One nightly cycle – Transparent transition – No corruption l Obstacles: – No place to test new server – Limited disk area for dump/recovery – Limited system memory 1/9/98 1998 Client Server Team Presentation: Sybase DBA 6

Success Rate l No Corruption of databases! l 1. 5 days to bring up the server. l Login problems on day #1. 1/9/98 1998 Client Server Team Presentation: Sybase DBA 7

Success Rate l No Corruption of databases! l 1. 5 days to bring up the server. l Login problems on day #1. l Lessons learned: Better performance in future transitions. 1/9/98 1998 Client Server Team Presentation: Sybase DBA 8

CDR? 1/9/98 1998 Client Server Team Presentation: Sybase DBA 9

CDR? l Corruption Problems. – Hardware Related – No Inserts or Indexes l Obstacle: – How to correct a 39 GB database during a typical weekend outage, quickly 1/9/98 1998 Client Server Team Presentation: Sybase DBA 10

Results l Corruption was corrected. l Hardware issues resolved. l Re-creation of tables : disk defragmented. l All Indexes recreated : index allocation optimized. 1/9/98 1998 Client Server Team Presentation: Sybase DBA 11

Better Performance! Questions? 1/9/98 1998 Client Server Team Presentation: Sybase DBA 12