What's New in ASE 15.7 ESD#2

    By: Mr. Vinod Chandran on Sep 04, 2012

    Explosive growth in data volumes are making organizations rethink the manner in which they have to manage data. Organizations are now working on efficiently managing not only historical data but also operational data stores running transactional as well as operational reporting systems. Gone are the days where hundreds of gigabytes of data was considered very large volume of data. Organizations are trying to manage tens of terabytes of data for an operational store.

    SAP Sybase Adaptive Server Enterprise 15.7. ESD2 is a follow up to ASE 15.7 which was designed to address the challenges of terabyte-scale operational environments. ASE 15.7 ESD#2 has enhanced ASE 15.7 specifically in the area of VLDB performance, security as well as monitoring and diagnostics.

    ASE 15.7 had introduced the following functionality to address data explosion:

    Storage Optimization

    • Compression
    • In-row LOBS
    • Non-materialized non-NULL column creation without data copy
    • Ability to shrink transaction logs

    Application Developer Productivity

    • Simpler and more efficient LOB retrieval and manipulation
    • Greater flexibility around concurrency and isolation levels
    • Enhanced SQL expressiveness
    • Support for scripting languagedrivers

    Monitoring and Diagnostics

    • Ability to save abstract plan information in the statement cache
    • Ability to output cached plan in XML
    • Ability to analyze dynamic parameters before running a query (helps avoid inefficient query plans)
    • Ability to monitor lock timeouts
    • Ability to display statistics and histograms for various objects, via a system procedure
    • Ability to monitor cursor statements
    • Ability to analyze the query plan generated to understand the various factors behind ASE's choice of the query plan

    Security administration

    • Object ownership change
    • Support for login profiles
    • Split knowledge/Dual control for protecting encryption keys
    • Improved encryption for FIPS 140-2 compliance
    • Single sign-on and end-to-end Kerberos credential forwarding


    • Reducing query latency, especially for dynamic SQL
    • ASE Kernel updates to better utilize parallel hardware 

    Login to read the article. Not a member? Create a free account!




    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk