An XEvent a Day (6 of 31) – Targets Week – asynchronous_file_target

Posted by Jonathan Kehayias on SQL Blog See other posts from SQL Blog or by Jonathan Kehayias
Published on Mon, 06 Dec 2010 14:00:00 GMT Indexed on 2010/12/06 16:58 UTC
Read the original article Hit count: 684

Yesterday’s post, Targets Week - ring_buffer , looked at the ring_buffer Target in Extended Events and how it outputs the raw Event data in an XML document.  Today I’m going to go over the details of the other Target in Extended Events that captures raw Event data, the asynchronous_file_target. What is the asynchronous_file_target? The asynchronous_file_target holds the raw format Event data in a proprietary binary file format that persists beyond server restarts and can be provided to another...(read more)

© SQL Blog or respective owner

Related posts about Extended Events

Related posts about SQL Server 2008