CREATE VIEW sys.dm_exec_query_resource_semaphores AS
	SELECT sysconv(smallint, ~sysconv(bit, isnull(max_target_memory_kb, -1) +1)) as resource_semaphore_id,
	target_memory_kb, max_target_memory_kb, total_memory_kb, available_memory_kb, granted_memory_kb,
	used_memory_kb, grantee_count, waiter_count, timeout_error_count, forced_grant_count,
	pool_id
	FROM OpenRowset(TABLE DM_EXEC_QE_RESSEM)