Rule of thumb
In case this is a standalone dbhost - and assuming you do not have an named thread pools in ASE:
thread count in syb_default_pool = #physical cores - 2
That leaves some space for OS and other ASE thread activity in syb_blocking_pool and syb_system_pool.
In any case I strongly discourage configuring online engines higher than # physical cores. That bears a very high risk of spinlock contention.
HTH
Tilman
Add comment