question

FrancescoPaoloLaGamba-6431 avatar image
0 Votes"
FrancescoPaoloLaGamba-6431 asked Cathyji-msft commented

SSMS wait e veeeeeeeery long time when I try to save a .xel file to a sql server table.

Hi, I am using last version of SSMS (18.9.2).

If I open a .xel file with ~2000 events in it and I try to export to SQL Server Table,
the program remains in "not responding" state for about 10 minutes or more.
This behavior is not present in another version of SSMS ( SQL-Server 2014)
What happens?
Best regards
Francesco Paolo La Gamba



sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FrancescoPaoloLaGamba-6431,

Just checking in to see if the response(s) could help you. If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered FrancescoPaoloLaGamba-6431 commented

I'm unfamiliar with that function, but why not read it directly with sys.fn_xe_file_target_read_file?

Then again, reading and analysing XEvent data is ridiculuous slow because of all that XML.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Erland,Thanks for the quick reply.
I also tried the road you recommended.
However I am left with the doubt that previous versions of SSMS does'n have this problem.
I therefore hope that Microsoft will fix what appears to me to be an obvious bug.

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @FrancescoPaoloLaGamba-6431,

I used SSMS 18.9.1 to test this, it works well.
125498-screenshot-2021-08-23-161559.jpg

There are other options to view XEvent event_file data.

  1. Open .XEL with menu File > Open > File;

  2. Management > Extended Events > Sessions > [your-session] > [your-target-node] > View Target Data;

  3. using sys.fn_xe_file_target_read_file;

Please refer to MS document Advanced Viewing of Target Data from Extended Events in SQL Server to get more information.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.