ASE 15 Migration Resources

Getting Started with ASE 15 Migration

The ASE 15 Migration Guide and Checklist provides the steps for a successful ASE 15 migration.

TECHNICAL RESOURCES

ASE 15 Migration White Papers

• Security Configuration Benchmark for Sybase ASE 15.0.x
• Required SQL Code Changes When Migrating To ASE 15
• Using 'Compatibility Mode' In ASE 15.0.3 ESD#1 For ASE 15 Migration
• Sybase ASE 15 Best Practices: Query Processing & Optimization
• Top 10 Reasons for Developers to Upgrade to ASE 15.0
• Handling Long-running Rollbacks and Recovery in Adaptive Server
• Top 10 Server Configuration Tips for a New ASE 15 Installation
• ASE 15 Troubleshooting Guide: Error Messages Advanced Resolutions
• Database Encryption Design Considerations and Best Practices for ASE 15
• Boosting Database Performance and Easing Maintenance Tasks with Data Partitioning in ASE 15
• ASE 15 and the Optimizer Statistics – More Influential Than Ever

ASE 15 In-Depth Presentations

• Upgrading to ASE 15 - An in-depth view of the (un)expected

Education Courses

• EDB554: ASE 15 Post-Migration Performance Tuning (Free Course)
• EDB366: Powering Up with ASE 15.0 - 2 days

Features in ASE 15.0.3 ESD#1

Query Processing Tuning(QPTune) 

• A query analysis tool that identifies "problem" queries i.e. those that runs slow on ASE 15 by capturing query text and a variety of metrics that include elapsed time, logical and physical I/O.
• A statistics advisory function that will identify and create missing statistics that is fundamental to the ASE 15 optimizer to choose correct plans.
• Be able to compare metrics across multiple runs and be able to tune ASE both at a server and a query level. 

Compatibility Mode 

• Take existing applications and move them to ASE 15 without any level tuning
• Save time on tuning operations
• Quick out of the box migration with ASE 15 new query engine