We have set gtc 4 as we have a OpsCenter with 4 logical CPUs as per http://www.symantec.com/docs/HOWTO41821
but seeing dbsrv12.exe using 100% on 1 CPU and almost nothing on the 3 other CPUs
Wondered if others had seen similar behaviour
After the upgrade to 7.7 the problem seems to have disappeared :)
After the upgrade to 7.7 the problem seems to have disappeared :)
Found this technote http://www.symantec.com/docs/TECH190207 which seems to describe a similar for version 7.5.0.1.
Didn't find anything in the performance_diagnostic output, but isn't that strong in sybase so can easily have missed something.
This happens all the time. If I understand it correctly, gtc 4 means that the db can run 4 processes (queries, stored procs, etc) at one time. It doesnt mean that one complex query can always be split between 4 cores.
Not sure how other DBs handle this but Sybase ASA has never been great at multithreading so I wouldnt be surprised if this is a limitation of this particular DB.
Usually databases is pretty good at multi threading, but of course it requires that the code/queries is written with multi threading in mind.
After a little digging and confering with my collegues, we now suspect the problem to be related in some way to the alert policies
