Skip to Content

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:

TPS

SP/SEC:

SPS

PRIORITY CHANGES:

PRIO

CACHE SEARCHES:

CACHE

TEMPDB CACHE USAGE:

TDB

DEFAULT DATA CACHE USAGE:

DDC

THREADED VS PROCESS KERNEL – IO:

IO

RPROCMGR SPINLOCK:

MGRSPIN

SSQLCACHE SPINLOCK:

SSQLSPIN

As promised, I will do further refinement to the data and post here when available.

ATM.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply