Question: I'm trying to read the Microsoft SQL Server Extended Event Log File - xel file for the SQL Server Extended Events system_health extended event. Just opening it up in Notepad - produces human unreadable output . How can I read the Extended Event Log File output file , using t0-sql? Answer: Microsoft have provided various methods and SQL functions which can read the Extended Event Log File file . There are multiple options. It is possible to list out the records within the Log file - this option will return a recordset, as xml output. You may want to... Read more →