ASE Offers Enhancements in Operational Scalability
Database maintenance windows are shrinking, and data volumes are only getting bigger; they are unfortunate realities in capital markets. Fortunately, high availability and operational scalability are on the rise with major innovations in the latest version of Sybase Adaptive Server Enterprise.
Last week’s webcast “Enhancements in Operational Scalability” discussed ASE 15.7’s ability to optimize data storage and reduce the time required to perform traditionally intensive maintenance activities. Sybase Director of Technical Engineering Jeff Tallman was the main speaker of the online event, covering capabilities such as QP latency reduction, fully-recoverable DDL and shared “inline” column defaults, as well as how to shrinking the transaction log and alter table without data copy.
“Version 15.7 improves ASE’s ability to scale with large numbers of users and larger schemas without significantly increasing the amount of resources to do so, improving availability and decreasing maintenance downtime,” Tallman said. “Sharing fully-prepared statements across connections and sessions, and sharing column defaults, reduce the overhead within procedure cache and improve concurrency despite high user concurrency or large schemas.”
Many database administrators are straining under an increasingly oppressive workload, operating around the clock, all week long, while their maintenance windows diminish — or vanish — and their data volumes only get bigger. They require improved operational scalability.
Imagine conducting operations without the need for extensive downtime; supporting large numbers of users without large overhead in resource usage; performing wide-scale changes without tedious and repetitive operations; and recovering quickly without, again, extensive downtime.
ASE 15.7 features that address these needs include QP latency reduction, fully-recoverable DDL, shrinking the transaction log, alter table without data copy and shared “inline” column defaults.
“A fully-recoverable DDL prevents recoverability issues, while shrinking the transaction log can dramatically improve a DBA’s ability to temporarily extend the transaction log,” Tallman said. “Simply temporarily extend the log using file system devices to recover from a log suspension, and revert back to the desired database size once the problem is over.”
Click here for a copy of the webcast presentation and to view the replay.
The final webcast in the five-part series, “Introducing ASE 15.7’s New Threaded Kernel,” will run live on Nov. 15. Sybase senior director of engineering Peter Thawley will talk about the new thread-based kernel introduced in ASE 15.7 that significantly streamlines I/O handling and improves application partitioning capabilities. To register for this final session, click here.