September 20, 2017 at 3:02 am
Dear Experts,
Can any body advise what does a high count (over 7000) of memory ring buffers EXCEPTIONS indicate . The record column in the query result for ring buffers some some error related info I suppose ,as in a sample record below . Thank you.
<Record id = "14957381" type ="RING_BUFFER_EXCEPTION" time ="7482291863"><Exception><Task address="0x00000000006AA988"></Task><Error>3617</Error><Severity>25</Severity><State>23</State><UserDefined>0</UserDefined></Exception><Stack><frame id = "0">0X0000000000F93A36</frame><frame id = "1">0X0000000000D5F524</frame><frame id = "2">0X0000000001EDE431</frame><frame id = "3">0X0000000074AEBF40</frame><frame id = "4">0X0000000074A8964E</frame><frame id = "5">0X0000000077C6B681</frame><frame id = "6">0X0000000000A20B14</frame><frame id = "7">0X0000000000A20BB8</frame><frame id = "8">0X0000000000A203CC</frame><frame id = "9">0X0000000000A26AC0</frame><frame id = "10">0X0000000000A26902</frame><frame id = "11">0X0000000000A23682</frame><frame id = "12">0X0000000001058B83</frame><frame id = "13">0X0000000000A51C40</frame><frame id = "14">0X0000000000A51D24</frame><frame id = "15">0X0000000000A71882</frame></Stack></Record>
September 20, 2017 at 7:01 am
Arsh - Wednesday, September 20, 2017 3:02 AMDear Experts,
Can any body advise what does a high count (over 7000) of memory ring buffers EXCEPTIONS indicate . The record column in the query result for ring buffers some some error related info I suppose ,as in a sample record below . Thank you.<Record id = "14957381" type ="RING_BUFFER_EXCEPTION" time ="7482291863"><Exception><Task address="0x00000000006AA988"></Task><Error>3617</Error><Severity>25</Severity><State>23</State><UserDefined>0</UserDefined></Exception><Stack><frame id = "0">0X0000000000F93A36</frame><frame id = "1">0X0000000000D5F524</frame><frame id = "2">0X0000000001EDE431</frame><frame id = "3">0X0000000074AEBF40</frame><frame id = "4">0X0000000074A8964E</frame><frame id = "5">0X0000000077C6B681</frame><frame id = "6">0X0000000000A20B14</frame><frame id = "7">0X0000000000A20BB8</frame><frame id = "8">0X0000000000A203CC</frame><frame id = "9">0X0000000000A26AC0</frame><frame id = "10">0X0000000000A26902</frame><frame id = "11">0X0000000000A23682</frame><frame id = "12">0X0000000001058B83</frame><frame id = "13">0X0000000000A51C40</frame><frame id = "14">0X0000000000A51D24</frame><frame id = "15">0X0000000000A71882</frame></Stack></Record>
You need to shred the xml to get the errors for it to mean much. Otherwise, all it means is there are a lot of ring buffer exceptions. If they are all 3617 that is usually due to canceling queries, command timeouts where the query starts and is killed or canceled from the client side. Or you can get those when you have a high volume of traffic and connections from connection pooling have to reset their connections.
If you are going to shred the xml, in addition to get the error numbers, you would want to include the date and time of the errors.
You can find an example of getting the information for the ring buffer exceptions in the following article - there is a section for RING_BUFFER_EXCEPTION if you only want those record types:
Inside sys.dm_os_ring_buffers
Sue
September 21, 2017 at 5:10 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply