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
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
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
Thanks for your help.
Thanks for your help.