ASE 15.7: More Comparisons…

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.

Advertisements

3 comments

  1. Tim Mottershead · · Reply

    Which charts are which, Andrew? I am guessing the following:
    Left: v15.7 Threaded kernel
    Middle: v15.7 Process kernel
    Right: v12.5.4

    1. Left is 12.5.4, Middle is 15.7 – threaded kernel, Right is 15.7 process kernel.
      You may also notice the right-most x value in each graph to be avg# (avg125/avg157T/avg157P)…

  2. Tim Mottershead · · Reply

    Thanks for the clarification, Andrew.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: