Category ASE Process Kernel

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