July 31, 2015 at 1:17 pm
Hello Experts,
The below query will help me reading the data in XML format but does anyone has any query to read from each column of XML tags easily?
Please share with me the query!
Thanks to all.
SELECT CAST(record AS XML), record
FROM sys.dm_os_ring_buffers
WHERE ring_buffer_type = 'RING_BUFFER_CONNECTIVITY'
Thanks.
August 1, 2015 at 11:53 am
A terrific blog for reading the details found in sys.dm_os_ring_buffers (including the query you seek) may be found here:
https://bwunder.wordpress.com/2012/07/29/monitoring-and-troubleshooting-with-sys-dm_os_ring_buffers/
-Eddie
Eddie Wuerch
MCM: SQL
August 3, 2015 at 11:20 am
Hi Eddie
Can you please resend the link? Seems like the page does not exist. 🙁
Thanks.
August 3, 2015 at 11:47 am
There's a stray newline at the end of the link. Copy and paste, or click on the link and edit it in the address bar.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 3, 2015 at 11:49 am
Eddie Wuerch (8/1/2015)
A terrific blog for reading the details found in sys.dm_os_ring_buffers (including the query you seek) may be found here:https://bwunder.wordpress.com/2012/07/29/monitoring-and-troubleshooting-with-sys-dm_os_ring_buffers/
-Eddie
Fixed link:
https://bwunder.wordpress.com/2012/07/29/monitoring-and-troubleshooting-with-sys-dm_os_ring_buffers/
August 3, 2015 at 1:22 pm
Thanks Everyone for sharing with me the nice link.
Thanks.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply