Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Using SQLA 11.0.1.2789, is there a maximum value for the -gn option?

asked 25 Jun '13, 14:47

lstavinoha's gravatar image

lstavinoha
71228
accept rate: 0%

edited 25 Jun '13, 15:30

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297


The maximum value for the number of workers in SA is:

  • 500 if you are running 32bit server on Windows,
  • 4096 if you are using a 64bit server on Windows,
  • 50 if you are using SA on Windows CE,
  • ~480 if on Solaris or HPUX, and
  • ~4064 if on one of the other Unix platforms (Linux, Mac OSX, AIX).

The above numbers are valid for at least v9 through v16.

HTH

permanent link

answered 25 Jun '13, 15:30

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297
accept rate: 41%

edited 25 Jun '13, 15:33

You should be really careful when attempting to change the database server's -gn switch and you should be aiming to adjust it to a value that makes sense for your workload, not a documented 'maximum'. This is more of a practical limit for your workload situation - it will be different for each specific database use-case and hardware situation.

I would highly recommend first reading through this section of the documentation that talks about the effects of changing this value: http://dcx.sybase.com/index.html#1101/en/dbadmin_en11/running-s-3713576.html

While increasing the number of workers may improve your overall operation if there are a large number of unscheduled requests, increasing the number of workers unnecessarily will take away memory and resources from other workers and may cause higher amounts of contention, actually lowering throughput.


Since it's understood that this testing process is very experimental in nature and isn't practical to be run in each and every installation site, we now have automatic worker tuning in SQL Anywhere 12 and above.

permanent link

answered 25 Jun '13, 15:43

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

edited 25 Jun '13, 16:38

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×143
×14
×10

question asked: 25 Jun '13, 14:47

question was seen: 2,531 times

last updated: 25 Jun '13, 16:38