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, I will do further refinement to the data and post here when available.

ATM.