sa_cpu_topology system procedure

sa_cpu_topology( )

Column name	Data type	Description
os_id	UNSIGNED INTEGER	Returns the logical processor identifier used by the underlying operating system. For example, on Windows this value matches the processor ID that appears in the Windows Task Manager.
socket	UNSIGNED INTEGER	Returns a CPU socket or package identifier.
core	UNSIGNED INTEGER	Returns an identifier for a core within a specific socket.
thread	UNSIGNED INTEGER	Returns an identifier for a thread within a specific socket and core.
apic	UNSIGNED INTEGER	Returns an identifier for the logical processor within the system. It contains the encoding of the socket, core, and thread.
"group"	UNSIGNED INTEGER	Returns the processor group number as assigned by the operating system on Windows. On Solaris, it is the processor set identifier. Otherwise, it is 0.
numa_node	UNSIGNED INTEGER	Returns the NUMA node assigned by the operating system on Windows.
online	BIT	Returns 1 if and only if the processor is online.
in_use	BIT	Returns 1 if the logical processor described by the current row is enabled in the process affinity mask for the SQL Anywhere database server process, and 0 otherwise.

On all 32-bit and 64-bit Intel x86/x64 platforms (except for Mac versions where processor affinity cannot be controlled), the information returned by this procedure accurately describes the underlying hardware. On all other platforms, there is one row per logical processor in the system, but the column values are set as follows: os_id, socket, and apic are equal; core and thread are zero; core thread, and numa_node are zero, and group is also zero except on Solaris where it is the pset identifier. On some VM implementations, the results may not be accurate.

None

The following example returns a result set containing the processor topology of the computer that the database server is running on.

CALL sa_cpu_topology( );

sa_cpu_topology system procedure

Syntax

Result set

Remarks

Privileges

Side effects

See also

Example