Unanswered: Sybase ASE 15.0.3 in IBM P780 with aix 6.1 TL09 SP04
we have heavy spinlock issue in our test environment. when the DB processes crosses nearly 5200, all ASE engines CPU usage
goes beyond 90% - hence subsequent users unable to login to the system. we have 300 GB memory for ASE with SMT=2 and
have 24 physical CPUs enabled with 32 ASE engines.
what may be the reason - which area we have to analyse to avoid this bottleneck.