THIS TOPIC APPLIES TO:SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
An internal component named the SQLOS creates node structures that mimic hardware processor locality. These structures can be changed by using soft-NUMA to create custom node layouts.
The following table provides information about these nodes.
To call this from Azure SQL Data Warehouse Public Preview or Parallel Data Warehouse, use the name sys.dm_pdw_nodes_os_nodes.
ID of the node.
Description of the node state. Values are displayed with the mutually exclusive values first, followed by the combinable values. For example:
Online, Thread Resources Low, Lazy Preemptive
There are four mutually exclusive node_state_desc values:
There are three combinable node_state_desc values:
Address of memory object associated with this node. One-to-one relation to sys.dm_os_memory_objects.memory_object_address.
Address of memory clerk associated with this node. One-to-one relation to sys.dm_os_memory_clerks.memory_clerk_address.
Address of worker assigned to IO completion for this node. One-to-one relation to sys.dm_os_workers.worker_address.
ID of the memory node this node belongs to. Many-to-one relation to sys.dm_os_memory_nodes.memory_node_id.
Bitmap identifying the CPUs this node is associated with.
Number of online schedulers that aremanaged by this node.
Number of online schedulers that have no active workers.
Number of workers that are active on all schedulers managed by this node.
Average number of tasks per scheduler on this node.
Bitmap identifying the schedulers that can have timer tasks assigned to them.
Bitmap identifying the schedulers that can have permanent tasks assigned to them.
Each node has one resource monitor assigned to it. The resource monitor can be running or idle. A value of 1 indicates running, a value of 0 indicates idle.
Identifies the process affinity mask for this node.
Identifies the group of processors for this node.
The identifier for the node that this distribution is on.
On SQL Server requires VIEW SERVER STATE permission on the server.
On SQL Database Premium Tiers requires the VIEW DATABASE STATE permission in the database. On SQL Database Standard and Basic Tiers requires the SQL Database admin account.