OpsCenter 7.6.0.4 dbsrv12.exe using 100% on 1 CPU with gtc 4

[Michael_G_Ander]

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

[Michael_G_Ander]

After a little digging and confering with my collegues, we now suspect the problem to be related in some way to the alert policies

[Michael_G_Ander]

Usually databases is pretty good at multi threading, but of course it requires that the code/queries is written with multi threading in mind.

[areznik]

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. 

[Michael_G_Ander]

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.

[Michael_G_Ander · Accepted solution]

After the upgrade to 7.7 the problem seems to have disappeared :)