Extended Events Export to table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » Extended Events Export to table

Extended Events Export to table

Rate Topic

Display Mode

Topic Options

Author

Message

DominantDBA

Posted Wednesday, February 27, 2013 3:12 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:13 AM
Points: 73, Visits: 263

Hi All

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?

Thanks
Chris

Post #1424424

Grant Fritchey

Posted Wednesday, February 27, 2013 4:55 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,375, Visits: 25,159

Instead of opening it up within the GUI, just run a query directly against it using sys.fn_xe_file_target_read_file

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1424468

DominantDBA

Posted Friday, March 01, 2013 8:04 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:13 AM
Points: 73, Visits: 263

Thanks Grant. Meant to get back to this but have been swamped

It 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 direction

Another 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:\ drive

Post #1425529

« Prev Topic | Next Topic »

Permissions