Please create a redistributable command-line equivalent for SSMS -> Extended Events -> Export
We've created a .NET C# based export for XEL to CSV using QueryableXEventData but it takes 4 minutes to export a 1GB file. In SSMS, clicking Extended Events -> Export -> CSV takes 45 seconds for the same file.
Unfortunately, interative SSMS is required, so the process cannot be automated. Please create a command-line executable so we can automate the export at the delicious speeds of SSMS.
Also, if the NULL can be removed from output in both SSMS and the command line tool, that would be far better.
Since it looks like you’re in the same ballpark as SSMS we will focus on other items for now.
Looks like we were missing streaming and now got it down to 67 seconds, which is far more reasonable 👍 Would still like a command line version but not as pressing ;)
Got it! 10-15 seconds to load into SSMS 17.4 then 45 seconds to export.
So 60 seconds total. Our .NET export is still at quadruple that, 240 seconds.
Aw I didn't notice your comment! I'll ask Gianluca, he had the 1gb file.
David Shiflet [MSFT] commented
SSMS takes 45 seconds just to export? How long to load the file first?