SYBASE DBA

1
SYBASE DBA

• Migrating to Sybase System 11.5 the
  Maintenance of CDR
• Brian Ramey

2
What You Will Learn

• System 11.5. Why and How we migrated?
• CDR, behind the scenes.
• Every question Ill ask will have the same
  answer, Better Performance.
• Brians addition to sign language.

3
Why we Migrated to System 11.5
4
Why we Migrated to System 11.5

• Better Performance.
• More Parallelism
• Better Memory Management

5
Why we Migrated to System 11.5

• Easier Maintenance.
• DDL objects are created faster
• New dbcc command
• Sybase will soon not support previous versions
• Sysaudits without the wait (coming soon)

6
How we migrated to System 11.5

• Goals
• One nightly cycle
• Transparent transition
• No corruption
• Obstacles
• No place to test new server
• Limited disk area for dump/recovery
• Limited system memory

7
Success Rate

• No Corruption of databases!
• 1.5 days to bring up the server.
• Login problems on day 1.

8
Success Rate

• No Corruption of databases!
• 1.5 days to bring up the server.
• Login problems on day 1.
• Lessons learned Better performance in future
  transitions.

9
CDR?
10
CDR?

• Corruption Problems.
• Hardware Related
• No Inserts or Indexes
• Obstacle
• How to correct a 39 GB database during a typical
  weekend outage, quickly

11
Results

• Corruption was corrected.
• Hardware issues resolved.
• Re-creation of tables disk defragmented.
• All Indexes recreated index allocation
  optimized.

12
Better Performance!

• Questions?