locked
SQL Audit Processing RRS feed

  • Question

  • Fellow SQLers,

    Regarding SQL Audit, I understand that it is running Extended Events inside. My assumption is that it is using the transaction log to get the info it is looking for.

    Is this correct or is it doing it a different way?

    Thx

    MG

    Friday, January 10, 2020 6:19 PM

Answers

  • Yes, auditing is using the underlying framework for Extended Events. But to my knowing it does not use the transaction log.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Marked as answer by mg101 Saturday, January 11, 2020 10:57 PM
    Saturday, January 11, 2020 10:40 AM

All replies

  • Yes, auditing is using the underlying framework for Extended Events. But to my knowing it does not use the transaction log.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Marked as answer by mg101 Saturday, January 11, 2020 10:57 PM
    Saturday, January 11, 2020 10:40 AM
  • thanks Erland
    Saturday, January 11, 2020 10:57 PM