SQL Anywhere database - Taking advantage of multiple processors

Author

Taking advantage of multiple processors

Jon

2006-02-15, 1:23 pm

ASA 8.0.2.4339

I'm looking for info on how to take advantage of multiple
processors using SMP or multi-threading. I've found some
info in the help file regarding different command line
switches but that doesn't really help me..

ASA 8 does support SMP and multi-threading, right? Can
someone give me some good insight in to what to look for or
try if my main goal is improving performance using multiple
processors?

Thanks.

Greg Fenton

2006-02-15, 1:23 pm

Jon wrote:
>
> ASA 8 does support SMP and multi-threading, right?

Yes.

> Can
> someone give me some good insight in to what to look for or
> try if my main goal is improving performance using multiple
> processors?
>

As with most everything in SQLAnywhere, ASA attempts to "do the right
thing" out of the box. By default, ASA will make use of all the CPUs
you are licensed to use.

For more information on multiple CPUs, check the documentation for the
"-gt" and "-gx" options for "dbsrv8":

Adaptive Server Anywhere Database Administration Guide
5. The Database Server
The database server
Database server options
-gt server option
and
-gx server option

as well as:

Adaptive Server Anywhere Database Administration Guide
1. Running the Database Server
Some common options
Controlling threading from the command line

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/

Breck Carter [TeamSybase]

2006-02-15, 8:23 pm

AFAIK different connections will make use of different CPUs, but a
single connection is (currently) constrained to run on one.

I have personal *anecdotal* evidence that indicates some single
processes (e.g., a giant reload) will exercise two CPUs, but I do not
have knowledge of the internal workings.

Breck

On 15 Feb 2006 11:15:55 -0800, Jon wrote:

>ASA 8.0.2.4339
>
>I'm looking for info on how to take advantage of multiple
>processors using SMP or multi-threading. I've found some
>info in the help file regarding different command line
>switches but that doesn't really help me..
>
>ASA 8 does support SMP and multi-threading, right? Can
>someone give me some good insight in to what to look for or
>try if my main goal is improving performance using multiple
>processors?
>
>Thanks.

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Ian McHardy

2006-02-17, 8:23 pm

Note the personal server is limited to 2 processors, and the runtime is
limited to 1. The Network server uses all processors on your machine.

--

Ian McHardy (iAnywhere Solutions)

Please reply only to the newsgroup.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
<Jon> wrote in message news:43f37deb.599b.1681692777@sybase.com...
> ASA 8.0.2.4339
>
> I'm looking for info on how to take advantage of multiple
> processors using SMP or multi-threading. I've found some
> info in the help file regarding different command line
> switches but that doesn't really help me..
>
> ASA 8 does support SMP and multi-threading, right? Can
> someone give me some good insight in to what to look for or
> try if my main goal is improving performance using multiple
> processors?
>
> Thanks.

Sponsored Links