Forum Discussion
- Michael_G_AnderLevel 6
After the upgrade to 7.7 the problem seems to have disappeared :)
- Michael_G_AnderLevel 6
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.
- areznikLevel 5
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_AnderLevel 6
Usually databases is pretty good at multi threading, but of course it requires that the code/queries is written with multi threading in mind.
- Michael_G_AnderLevel 6
After a little digging and confering with my collegues, we now suspect the problem to be related in some way to the alert policies
Related Content
- 10 years ago
- 10 years ago
- 7 years ago
- 6 years ago