Hello,
ASE 16 SP02 PL03 on RHEL 7.2
In order to reduce or get rid of the message "Spinlock Resource->rproccache_spin at address...", "Procedure Cache Spinlock (Resource->rproccache_spin)", ect
which TF should be used : TF 753 or TF 757 ?
I was checking https://wiki.scn.sap.com/wiki/display/SYBASE/Spinlocks+and+CPU+usage+in+SAP+ASE#
and I was just thinking which one it would be best.. or both ?
Thank you
Jose
See the following for discussions re: procedure cache (spinlocks), ELC and TFs 753/757:
I think TF753 has been superseded by the config setting
"enable large chunk elc" in Sybase 16
We have it set to 0 - although I'm told Sybase 16 works better than Sybase 15.7 with large chunk elc.
However, we haven't tried it so can't comment how well it works.
Hi Mike,
In 16.0:
TF 753 is replaced by "large allocation auto tune"
TF 758 is replaced by "enable large chunk elc"
Thank you guys,
But still wondering:
-Is TF 757 is similar to TF753 ?[( if any one has the specifics on 757 it'll be great)
-According to "ASE Procedure Cache and Engine Local Cache (ELC)"
large allocation auto tune (replaces traceflag 753) -> we have set it to 0 for a while, but we are still getting this message followed by a stack trace:
"Spinlock Resource->rproccache_spin at address..."
then ,It's advisable to use 753 and eventually increase Proc cache ?
-Does TF 757 has been replaced by a new ASE parameter ?
Regards
Jose
Correction on my response : We have set "enable large chunk elc" to 0. So "large allocation auto tune" would it be advisable to switch it to 1?
Thank you
Jose
Hi Jose,
Keep in mind, the association with any of these trace flags and configurations have no bearing on whether or not normal processing requires rproccache_spin spinlock. These configurations change usage of the caches not the necessity of the spinlock when it is being used.
Asking how to get rid of "Spinlock Resource" issues during a stacktrace, is answered by getting rid of the stack trace. Spinlocks will be held anytime a protected memory address needs to be accessed. As long as there are multiple engines, multiple users competing for the same memory, you will have grabs as well as spins/waits for the spinlock.