How to create a list of long running processes

What I am really trying to do is create a list of the longest running GI’s and Dashboard’s in my instance to identify which ones take longer than 10 seconds to execute and/or pull the largest amount of data.  

The reason for this is to identify those GI’s and Dashboard’s that are having negative performance impacts and look to rewrite or retire those.

Thank you,

Jeff

Thank you @Missy Main.  I knew and have used both.  I was hoping for more diagnostic informative methods.  Again, thank you for the information and links!

@Missy Main Expanding on the original question - 
What we all need is a way to monitor processes that take a long time or many resources. It is not possible to catch these “live” all the time.
If an action takes more than x minutes to complete or more than x percentage of our SQL resources, we would like to know about it and potentially cancel the action or at least be aware that it is inefficient so we can optimize the process.

In recent builds, Acumatica has added similar functionality to the system queues. We can set a threshold which is crossed, an Email is triggered. The concept would be similar for SQL or application processes.


We tried creating a Business event from a GI based on the tables used in System monitor>Running Processes & System monitor>Requests in progress, but the data is either non-existent in the DB, or static.


To summarize - 
We are looking for either a native tool that will generate a notification based on performance parameters, or advice on how to create a GI that will allow for business event monitoring.


Thanks!



@jeffgrammer69 If you have found any workaround, we would love to hear about them!