I have a machine with 2 CPU's, and it looks like dbsrv6.exe takes only one
cpu per user session.

If I do a heavy SQL query which takes a lot of resources I see the CPU in
the taskmanager at 50%, the maximum of one CPU.
Then, if I do a second ISQL connection, at the same machine, I see the
processor usage increasing to 60 or 70%.

The online help says the db engine takes all cpu's by default. Or is -gt 2
necessary?

In article <3fd0ae5c$1@forums-1-dub>, jan (AT) van-veldhuizen (DOT) nl says...
IME, It uses 1 cpu per query.



--
Dave Kerber
Fight spam: remove the ns_ from the return address before replying!

REAL programmers write self-modifying code.

Jan van Veldhuizen wrote:

A single active query uses a single database task. A task will only use
a single CPU.

The database engine runs with multiple tasks. Each active task can run
on its own CPU subject to the availability of CPUs.

In the ASA 9.0.0 docs (I don't have 6.0 docs handy, sorry), see:

ASA Database Administration Guide
Running the Database Server
Some common options
Controlling threading from the command line
- Threading in Adaptive Server Anywhere

(Look up "tasks/about" in the 6.0 docs. Hopefully relevant info is there).

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/