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.
TEMPDB CACHE USAGE:
DEFAULT DATA CACHE USAGE:
THREADED VS PROCESS KERNEL – IO:
As promised, I will do further refinement to the data and post here when available.