How to do it...

  1. 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.
  2. With the XEL file open in SSMS, click on the Extended Events tab on the toolbar and select Export to at the bottom.
  3. 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 ...

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.