XE_BUFFERMGR_FREEBUF_EVENT WAITS

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 John.Sakalauskas 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
Cancel
Up 0 Down

Reply

Reject Answer

Cancel
0 miguelangel prieto over 4 years ago in reply to John.Sakalauskas

Thanks for your help.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 miguelangel prieto over 4 years ago in reply to John.Sakalauskas

Thanks for your help.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

No Data