SA17 not using the available cpu processors

[former_SQLA_member1694873]

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.

[VolkerBarth]

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)

[former_SQLA_member1694873]

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?

[VolkerBarth]

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...

[former_SQLA_member1694873]

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. 😞

[johnsmirnios]

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.

[former_SQLA_member1694873]

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?