Category Migration assistance

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: SP/SEC: PRIORITY CHANGES: CACHE SEARCHES: TEMPDB CACHE USAGE: DEFAULT DATA CACHE USAGE: THREADED VS PROCESS KERNEL – IO: RPROCMGR SPINLOCK: SSQLCACHE SPINLOCK: As promised, […]

ASE Migration Study: Prepared Statements and ASE 15.x

I have been silent for quite a while.  The reason for the silence is that I have been involved for the past two months in analyzing migration problems of two large local ASE sites.  Luckily, this is also history now. I decided to share with you the things discovered during the failed ASE 15 migration […]

SYBASE ASE: Logical Resource Manager Made Simple…

I did not intend to post on this, but it so has happened that I have found myself involved with studying the differences in the ASE 15.7 new kernel:  threaded as opposed to process.  There are a lot of differences in the new ASE.  But the difference in the way engine resources are treated in […]

This one is a killer: Sybase ASE Load Generator, Sybase ASE Execution Statistics Analyzer, Sybase ASE Code Player &c…

Remember the teaser I published a couple of weeks ago?    I have been finally able  to compile a reasonable “beta” version of the tool.  This one is really fun (not that the earlier tools were NOT fun, but this one is just that – FUN).  I have been using a much more simple version […]

Location for the Sybase Monitoring Tools Has Moved…

I know, this is a bit annoying, but when I realized that 4share site asks you to register in order to download files I’ve got a bit pissed off.  I did not read any warning that this will happen to those using the service (may have misread this actually).  But whether I was prompted and […]