sys.dm_os_hosts

Description

Analytics Platform System (PDW) Returns all the hosts currently registered in an instance of SQL Server. This view also returns the resources that are used by these hosts. Internal memory address of the host object. Type of hosted component.

Syntax

SELECT h.type, SUM(mc.pages_kb) AS committed_memory
FROM sys.dm_os_memory_clerks AS mc
INNER JOIN sys.dm_os_hosts AS h
ON mc.memory_clerk_address = h.default_memory_clerk_address
GROUP BY h.type;