Post reply

Large number of Memory Ring buffers

  • November 29, 2023 at 1:23 pm

    #4336649

    Hi Friends,

    As part of collecting different stats from the SQL servers  I have been asked to manage recently, I found the memory ring buffers on a server just crossed a million rows. Though I didnt get any complaints from the users, I would be glad if you can comment on this and indicate if this should be of concern.Thank you.

     

    Best Regards...Arshad

  • November 29, 2023 at 4:07 pm

    #4336754

    Presumably, that means a lot of Extended Events sessions outputing to the ring_buffers. Probably not the best way to go. Output to file is generally better. But, it does depend on whether or not the system is starved for memory.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply