Monthly Archives: February 2013

ASE 15.7 ESD#4 on SPARC…

I have just finished the first round of tests of ESD#4 on Solaris SPARC platform.  I have to confirm:  the ESD#4 seems to has been finally vaccinated against wasteful reuse of the statement/procedure cache by “inappropriate” use in client-side code.  It looks like the painful experience of seeing ASE suffocating unexpectedly under the stress generated […]

ASE 15.7: ESD#4 Updates….

ESD#4 has been around for some time.  I did not start testing the conditions I am pushing the ASE into with this EBF for several reasons.  But now it seems to really be a pity I haven’t done so from the start.  After making a few tests with ESD#2 on Solaris x64, and after making similar […]

ASE 15.7: Threaded vs. Process Kernel Mode.

So, the threaded or the process?  Which one would you select on your next migration? There is a clear recommendation in Sybase documentation to use the threaded kernel mode.  This recommendation, though, is precisely the opposite of what Sybase ASE DBAs would have naturally selected.  I have spoken to several customers that consider to move […]

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) ? […]