InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 01:13:44 GMT20http://www.sqlservercentral.com/Forums/Topic1424424-2799-1.aspxThanks Grant. Meant to get back to this but have been swampedIt seems Im going to have to get my hands dirty with XQuery to get what I want which isnt a bad thing.Thanks for pointing me in the right directionAnother alternative i found was that you can open up individual files and then export those to tables. This will mimize the size of the temp file that gets created. It isnt really ideal as it wil always created the temp file on the c:\ driveFri, 01 Mar 2013 08:04:35 GMTDominantDBAhttp://www.sqlservercentral.com/Forums/Topic1424424-2799-1.aspxInstead of opening it up within the GUI, just run a query directly against it using [url=http://msdn.microsoft.com/en-us/library/cc280743.aspx]sys.fn_xe_file_target_read_file[/url]Wed, 27 Feb 2013 04:55:47 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1424424-2799-1.aspxHi AllI 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 driveBefore 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?ThanksChrisWed, 27 Feb 2013 03:12:07 GMTDominantDBA