- Obtain access to the Extended Events target XEL target file and open it from SQL Server Management Studio (SSMS) or open it directly from Windows Explorer in a distinct instance of SSMS.
- With the XEL file open in SSMS, click on the Extended Events tab on the toolbar and select Export to at the bottom.
- Choose the Export to CSV File option, enter a file name describing the session, and select a network path common to Extended Events and potentially other performance and administrative log files.
An Extended Events Session Target XEL file and its export as a CSV file
By design, Extended Events sessions cannot be written to tables ...