What's the difference between MultiProgrammingLevel and CurrentMultiProgrammingLevel?

In Version 12, what's the difference between the two server properties MultiProgrammingLevel and CurrentMultiProgrammingLevel?

In my testing, they appear to be the same .... executing the command in dbisql:

CALL sa_server_option ( 'CurrentMultiProgrammingLevel', 25 );

changed the value of both properties to 25.

I'm using SA 12.0.1.3152

Thanks!

Margaret

property

asked 03 Mar '11, 20:08

Margaret Kam...
331●6●8●19
accept rate: 50%

flat view

One Answer:

active answers oldest answers newest answers popular answers

Note, this is just a guess:

IMHO, they should have the same value.

MultiProgrammingLevel is an older server property, introduced with V10, and comes from the time when the multiprogramming level was statically fixed at server start time (dbsrxX -gn).

CurrentMultiProgrammingLevel is one of those new properties to check the automatic tuning of the database server multiprogramming level introduced with V12. Others are AutoMultiProgrammingLevel, MaxMultiProgrammingLevel and MinMultiProgrammingLevel.

One might think that for V12, MultiProgrammingLevel could have been omitted (as it seems to have the same meaning as CurrentMultiProgrammingLevel) but was left for reasons of backward compatibility (which would sound reasonable, of course!).

permanent link

answered 04 Mar '11, 08:16

Volker Barth
39.7k●357●545●815
accept rate: 34%

edited 04 Mar '11, 17:22

Volker is correct - I checked the code and both return the same value. MultiProgrammingLevel has been retained for backward compatibility and has been replaced with the newer CurrentMultiProgrammingLevel as a result of the automatic tuning of MPL which was added in 12.

(04 Mar '11, 18:08) Mark Culp

Wow, so I did some kind of code review without having the code available? - That can only work since "Watcom does the things the way they should be done.":)

(05 Mar '11, 16:17) Volker Barth

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

property ×24

question asked: 03 Mar '11, 20:08

question was seen: 2,340 times

last updated: 04 Mar '11, 17:22

SAP SQL Anywhere

What's the difference between MultiProgrammingLevel and CurrentMultiProgrammingLevel?

Follow this question

Related questions