dm_os_nodesThis is a view in the mssqlsystemresource database. Returns a row for each host (such as an OLE DB provider) currently registered in an instance of SQL Server and each resource used by these hosts. Nodes are created by SQL OS to mimic hardware processor locality and can be altered by SQL OS using soft-NUMA techniques.
CREATE VIEW sys.dm_os_nodes AS
SELECT *
FROM OpenRowSet(TABLE DM_OS_NODES) |