WITH ts_now
AS ( SELECT dosi.ms_ticks FROM sys.dm_os_sys_info AS dosi )
SELECT DATEADD(ms, ( ts.ms_ticks - x.timestamp ), GETDATE()) AS event_date, rb.x.query('.')
FROM
( SELECT CONVERT(XML, dorb.record) AS record, dorb.timestamp
FROM sys.dm_os_ring_buffers AS dorb
WHERE dorb.ring_buffer_type = 'RING_BUFFER_RESOURCE_MONITOR' ) AS x
CROSS JOIN ts_now AS ts
CROSS APPLY x.record.nodes('/Record') AS rb(x);