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);