Include Stored Procedure performance
Include which stored procedures executed have high CPU, memory utilization, IO consumption. Also, include top wait types on Global Overview in addition to CPU and Memory
The most performance-relevant stored procedures and ad-hoc queries can be inspected with the “Performance Diagnostics” feature on the Instance and Database Overview screens. This information is also replicated in the Performance section of the alert details pages
Matt Sontum commented
I was told that the feature did not exist at this time:
"Unfortunately it's not available in Monitor at the moment. Can you kindly post your suggestion on user voice forum so that other people can vote for it?"
Although perhaps what I am looking for is slightly different. I will post again.
Thanks a lot for your suggestion.