• State Verified Answer
  • Replies 5 replies
  • Subscribers 59 subscribers
  • Views 6596 views
  • Users 0 members are here
Options
Related

XE_BUFFERMGR_FREEBUF_EVENT WAITS

miguelangel prieto
over 4 years ago

Hi, my Foglight is generating a lot of XE_BUFFERMGR_FREEBUF_EVENT waits in one of our SQL instance, causing a bad performance in some apps. Can I set up Foglight in anyway to avoid this waits?

Thanks

Parents
  • 0 over 4 years ago

    Hi Miguel Angel,

    Beginning with the SQL Server cartridge version 5.9.4.20 and higher, we began to use extended events default means to capture deadlock data.

    You might try editing the properties of the SQL Server agent in Administration | Agents | Agent Status, to change the ASP value "Deadlock working mode" from "Auto" to "Trace".

    John

Reply
  • 0 over 4 years ago

    Hi Miguel Angel,

    Beginning with the SQL Server cartridge version 5.9.4.20 and higher, we began to use extended events default means to capture deadlock data.

    You might try editing the properties of the SQL Server agent in Administration | Agents | Agent Status, to change the ASP value "Deadlock working mode" from "Auto" to "Trace".

    John

Children