Provide XEvents target directly into SQL Server table
Provide a way to directly write XEvent output directly into a SQL Server database table in a same or different instance and same or different database.
The goal being to be able to not have any events missed but have the entire stream captured to the table and also provide header information for when the capture table was created for easier management and deletion. Ideally there should be a purge task that could be activated to clean out such captures after X days.
XEvents is a great and powerful tool.
Customers should have an easier way to get it directly into SQL Server so they can consume the historization back via normal SQL syntax. XEvent output is structured in nature.
2 new target types in sys.dm_xe_objects would likely be helpful:
Appropriate Security management would need to be put in place.
Gianluca Sartori commented
XESmartTarget can fill this gap. Check it out here: https://github.com/spaghettidba/XESmartTarget
Vladimir Moldovanenko commented
SQL Server Broker was requested as a new target for Extended Events. Some parts of this were delivered in SQL 2017 but it still does not work.
Once this works you can capture and whatever you want with extended events, even INSERT these into your own table, either by RECEIVEing from queue or having activation procedure coded to do what you want.