Each time a query using
the SAS_EP stored procedure is invoked to execute a score, it requests
a set of semaphore arrays (sometimes referred to as semaphore "sets")
from the operating system. The SAS Embedded Process releases the semaphore
arrays back to the operating system after scoring is complete.
The SAP HANA server
that runs the SAS Embedded Process should be configured with a minimum
of 1024 to 2048 semaphore arrays.
Note: The semaphore limit on the
“maximum number of arrays” is distinct from the semaphore
limit on the “maximum number of semaphores system wide”.
The Linux
ipcs -sl command shows the typical
default semaphore-related limits set on SAP HANA:
------ Semaphore Limits --------
max number of arrays = 2048
max semaphores per array = 250
max semaphores system wide = 512000
max ops per semop call = 100
semaphore max value = 32767