on 2014 Nov 13 3:00 AM
a) If I run the SQL Anywhere Network Server Version 12.0.1.3967 with -gn option, then MaxMultiprogrammingLevel > 100:
a1) -cs -cl 3G -gns -gna 1 -gn 100 ==>
Minimum cache size: 3145728K, maximum cache size: 3149704K Multiprogramming level: minimum:4, current:100, maximum:400
a2) -cs -cl 3G -gns -gna 1 -gn 70 ==>
Minimum cache size: 3145728K, maximum cache size: 3272584K Multiprogramming level: minimum:4, current:70, maximum:280
a3) -cs -cl 3G -gns -gna 1 -gn 80 ==>
Minimum cache size: 3145728K, maximum cache size: 3231624K Multiprogramming level: minimum:4, current:80, maximum:320
b) But if I run the SQL Anywhere Network Server Version 12.0.1.3967 with -gnl option, then MaxMultiprogrammingLevel = 80:
b1.1) -cs -cl 3G -gns -gna 1 -gnl 100 ==>
Minimum cache size: 3145728K, maximum cache size: 3477384K Multiprogramming level: minimum:100, current:80, maximum:80
b1.2) -cs -cl 2G -gns -gna 1 -gnl 100 ==>
Minimum cache size: 2097152K, maximum cache size: 3477384K Multiprogramming level: minimum:100, current:80, maximum:80
b2.1) -cs -cl 3G -gns -gna 1 -gnl 70 ==>
Minimum cache size: 3145728K, maximum cache size: 3477384K Multiprogramming level: minimum:70, current:75, maximum:80
b2.2) -cs -cl 2G -gns -gna 1 -gnl 70 ==>
Minimum cache size: 2097152K, maximum cache size: 3477384K Multiprogramming level: minimum:70, current:75, maximum:80
Is this correct behavior -gnl option?
In my understanding, this is documented behaviour when you do not specify the -gnh option. Then the maximum multiprogramming level has the following
Default
Four times the -gn database server option value
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.