SA17 not using the available cpu processors

I'm running SQL Anywhere 17.0.8.4046 and just upgraded my VPS from 2 vCPSs to 8vCPUs, but the database doesn't seem to be using the additional CPUs. sa_eng_properties() reports:

278,'NumLogicalProcessors','Number of logical processors on server machine',8 279,'NumLogicalProcessorsUsed','Number of logical processors which the server will use',2 276,'NumPhysicalProcessors','Number of physical processors on server machine',8 277,'NumPhysicalProcessorsUsed','Number of physical processors which the server will use',2

I have not specified any of the multiprogramming switches -gn -gna -gnh and -gnl - I understand that the default is to use all the available processors allowed by the licence.

I wondered if there was a problem with the licence - the command dblic command returns

$ dblic /opt/sqlanywhere17/bin64/dbsrv17.lic
SQL Anywhere Server Licensing Utility Version 17.0.8.4046
License read successfully.
Workgroup Edition
Licensed nodes: 5
User: Terry Wilkinson
Company: Driftscape Corp.
Install key: xxxxx-xxxxx-xxxxx-xxxxx-xxxxx

I believe this means we have a 'per named-user' licence (5) which I understand is good for up to 8 cores (see this link

The report from dblic reports Workgroup Edition which is confusing because I'm sure we purchased the Edge edition, and the SAP https://launchpad.support.sap.com/#/licensekey/wizard portal reports 7018417 SAP SQL Anywhere, Edge Edition (user) and the install key reported by dblic matches that shown in that portal page.

I must confess I find the licensing model confusing. Am I missing a setting somewhere? Have I applied the licence incorrectly? Or failed to do so?

I would appreciate any help.

sa-17 cpu license

asked 20 May '19, 00:14

Terry Wilkinson
746●30●35●48
accept rate: 25%

edited 20 May '19, 00:16

I share the impression that the licensing situation is quite confusing - possibly the question "Core / Processor License Confusion may help...

Note, the first link you provided is not an official SAP link, I'd point you to this official one...

That being said, what does the console log say when the database server is started? It should list the available via licensed cores,something like

Processors detected: 4 logical processor(s) on 4 core(s) on 1 physical processor(s)
Processor license restriction (Personal Server): all logical processors on at most 4 core(s) on at most 1 physical processor(s)
This server is licensed to use: all logical processors on at most 4 core(s) on at most 1 physical processor(s)
Processors in use by server: 4 logical processor(s) on 4 core(s) on 1 physical processor(s)

(20 May '19, 03:25) Volker Barth

The console log is this:

Processors detected: 8 logical processor(s) on 8 core(s) on 8 physical processor(s)
Processor license restriction (Workgroup Edition): all logical processors on all cores on up to 2 physical processors
This server is licensed to use: all logical processors on all cores on up to 2 physical processors
Processors in use by server: 2 logical processor(s) on 2 core(s) on 2 physical processor(s)

It seems that the installation is not using the licence I think we have purchased. Is there a way to check that?

(20 May '19, 07:14) Terry Wilkinson

Replies hidden

In case you are certain that the registered license count does not fit your actual license, dblic with the -u option is your friend...

...until you re-read the question and notice the docs don't really tell how to modify the number of cores/processors when the license is not based on them...

(20 May '19, 08:18) Volker Barth

Thanks Volker. I'm still suspicious of the reference to "Workgroup Edition" so I decided to try my luck with SAP chat, got redirected to my account exec, and we'll see how that goes. I maybe don't have the license I think I have. :-(

(20 May '19, 12:33) Terry Wilkinson

Comment Text Removed

To me, it looks like you have a v16 Workgroup Edition licence which appears to be limited, as your console messages say, to 2 physical processors (sockets) but with no limit to the number of cores or threads on each physical processor. Since your VM only presents one core per socket, you end up only using 2 logical processors.

(20 May '19, 15:46) John Smirnios

I'm sure we purchased the Edge Edition with the per-named-user license - if I go to the SAP ONE Support Launchpad under License Keys, I see "7018417 SAP SQL Anywhere, Edge Edition (user)". The page at https://wiki.scn.sap.com/wiki/display/SQLANY/SAP+SQL+Anywhere+Editions seems to imply that I can have 8 cores with the Edge edition. How would I go about installing that license?

(20 May '19, 16:04) Terry Wilkinson

showing 4 of 6 show all flat view

Be the first one to answer this question!

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:

sa-17 ×222
license ×64
cpu ×4

question asked: 20 May '19, 00:14

question was seen: 1,663 times

last updated: 20 May '19, 16:25

SAP SQL Anywhere

SA17 not using the available cpu processors

Follow this question

Related questions