Category ASE Threaded Kernel

ASE 15.7: A Fight between Cheetah and Rhino…

It has been quite a long time since I have been able to write anything in this public space.   The reason is that I have been completely absorbed by one of the most exciting projects I have been managing for the last couple of years:   moving the largest ASE site in the country […]

ASE 15.7: Threaded Kernel vs. Process Kernel: Throughput Variance

I have just finished performing a controlled analysis of general performance differences for ASE 15.7 running process and threaded kernel mode on various platforms and hosts (RHEL running on Dell Xeon chips, Solaris running on SPARC M, SPARC T  and x64).  Although there are quite a few differences, the following image tells the story of […]

ASE 15.7: Threaded vs. Process Kernel Mode – Solaris/RHEL cross-tests

I am back with the comparative tests:  threaded kernel mode versus process kernel mode.  I have seen in  my earlier tests that process kernel mode seems to get slightly better throughput under the same workload.  On the other hand, I have also found that process kernel mode have shown certain types of unwanted behavior absent […]

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