March 30, 2016 at 3:20 am
We had created a extended events session to capture all the events . Unfortunately we didn't filter the events that were necessary and it created lots of events leading to sql services eating up resources . We have since disabled the session . Is there any way i can check the already captured events ? also is there any way we can export the file and check ?
March 30, 2016 at 4:04 am
It depends on what the target of the session was. If you output it to a file, then that file should be there. And yes, you should be able to read from it. If you output to ring buffers, no, that's gone. Plus, it's generally a bad habit to output to ring buffers. It does use more resources. Output to a file is better.
If you have a file, you can just open it in the Explorer window within SSMS. You can also use the extended procedure sys.fn_xe_file_target_read_file to query the file. It outputs XML, so you'll also need to deal with that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply