08-14-2015 01:25 AM
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
Solved! Go to Solution.
10-08-2015 05:01 AM
After the upgrade to 7.7 the problem seems to have disappeared :)
08-14-2015 02:11 AM
After a little digging and confering with my collegues, we now suspect the problem to be related in some way to the alert policies
08-14-2015 06:03 AM
Usually databases is pretty good at multi threading, but of course it requires that the code/queries is written with multi threading in mind.
08-14-2015 12:29 PM
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.
08-20-2015 02:45 AM
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.
10-08-2015 05:01 AM
After the upgrade to 7.7 the problem seems to have disappeared :)