Tag Archives: ASE 12.5 vs. ASE 15

ASE 15.7 Migration – A Rertospective

Years ago, still running on the old good 12.5 binaries of ASE, I remember coming across the article named “Top 10 Reasons for Developer to Upgrade to 15.0.”  I recalled it recently why working on yet another migration project which entered a crucial stage of decisions and questionings:  “Why should we upgrade at all?  We […]

LWPs: 12.5.4, 15.7, The Throughput Differences…

I have just finished a round of throughput checks for LWP performance between versions 12.5.4 and 15.7 – threaded & process kernel mode.   The comparison is a bit “unfair” since I compare 12.5.4 with statement cache disabled (it was in its diapers then), and 15.7 with the statement cache enabled + functionality group enabled […]

ASE 15.7: More Comparisons…

Some additional data you may find interesting.  This time we compare impact of the same workload on ASE 12.5.4 and ASE 15.7 – configured in threaded vs. process kernel mode. XACT/SEC: SP/SEC: PRIORITY CHANGES: CACHE SEARCHES: TEMPDB CACHE USAGE: DEFAULT DATA CACHE USAGE: THREADED VS PROCESS KERNEL – IO: RPROCMGR SPINLOCK: SSQLCACHE SPINLOCK: As promised, […]

ASE 15.7: Are you ready?

Ok.  So ASE 15.7 has been around for quite a while now.  But how many of us are really familiar with this new kid around the block?  How many of us have risked putting this beast to work in large production environment (by “us” I do not mean SAP users, but traditional ASE users community) ? […]

ASE Migration Study: Prepared Statements and ASE 15.x

I have been silent for quite a while.  The reason for the silence is that I have been involved for the past two months in analyzing migration problems of two large local ASE sites.  Luckily, this is also history now. I decided to share with you the things discovered during the failed ASE 15 migration […]