I kicked off a queries detail tracking(using an event file as data storage) extended events on my pre-prod environment yesterday which I ran for 5-6 hours yesterday amd then stopped it. Quite a lot of data was created(30gb) in *.xel files which was fine as it was being put on a large backup drive
Before I left work yesterday I wanted to export all this information to a table in order for me to do some tuning analysis. So I went right click->view target data then locked my computer and went home.
I came in this morning and was alarmed to find the c:\ drive out of space! Awesome
When you perform the above action SSMS creates a file on the folder C:\Users\[username]\AppData\Local\Temp\2 that is holding temporary results of what is on the view target data window.
I cant find a way to import the extended events xel files into a table in SSMS without doing the view target data thing?
Is there an easy way to do this?