How To Find Long Running Queries in SQL Server Using Extended Events - Tutorial

[@surendrasiddhi8502]

Thanks for the great tutorial. It is very helpful.

[@TheSQLGuy]

Glad you enjoyed it.

[@everyonesview]

Cheers for this, mate!

[@hindzaafouri930]

Hey , thank you for the tutorial , Is it possible to convert .xel files to .json please ?

[@TheSQLGuy]

Hi, it is possible although I've never done it myself but I can take a look if you wanted? It is also possible to read the contents of the XE via T-SQL. I use it to directly query the XE and insert the results into a table. I'm not sure if that helps your use case but I can take a look at converting it to json if you like?

[@nickrandles9031]

Hi, thanks for the tutorial. Can you please explain why the time for the 11 second query is stored as 11052568? Is it recorded in microseconds rather than milliseconds?

[@fuyfuy1]

yes, it's microseconds

[@CarrigansGuitarClub]

That was very good - do you know of other ways to capture long running queries?

[@TheSQLGuy]

Profiler would be one! Extended Events captures them while you aren't monitoring though and is very lightweight which is great. The problem is that you need to capture the RPC Completed event which shows when the query finished. You could create a Timeout XE which would show long running queries which have been terminated by the client, these wouldn't appear in the Long Running Queries XE. I've done a video on that also if you wanted?

[@Daavlot]

Very helpful, thank you!

[@dhir4010]

too small view..difficult to watch