Hi Team,
I want to find the long running queries in synapse and want to pin its results to dashboard.
I have sql query for this one
SELECT TOP 10 *
FROM sys.dm_pdw_exec_requests
ORDER BY total_elapsed_time DESC
But i want to run this in log analytics workspace so i can pin the results to dashboard.
I have checked in my log analytics workspace but i couldn't find any table there which has logs of synapse.
Please let me know how this can be done.
Thanks & Regards,
MSD






