MultiProgrammingLevel -gn maximum value 11.0.1

[Former Member]

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

[MarkCulp · Accepted solution]

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