Ability to search Redgate Monitor for activity on a particular stored procedure

Uri

Hi, Is there a way to search in Redgate Monitor for a particular stored procedure or sql fragment in order to retrieve the alerts associated with it or other stats? If you have any sql that you can share that would be helpful as well. Thanks!

DanC

Hi @Uri

Unfortunately, there's no specific way to search for a particular stored procedure or sql fragment. 

You may be able to find these in the top queries or top procedures.

https://documentation.red-gate.com/monitor/top-queries-239668180.html

https://documentation.red-gate.com/monitor/top-procedures-239668352.html

Uri

Thank you for your response. Even though in the UI of the tool there is no way to search, the data was saved to the application database, so is it possible to ask the developers for some helpful SQL queries to cull that information? Thanks again!

DanC

Hi @Uri

Unfortunately, unless you're using Redgate Monitor Enterprise with the Rest API, we don't support writing queries out of the DB.

Uri

Ok, Thank you. I guess I would want to put the question out there to the community if anyone has queried the application database (where all the usage data is stored) to cull information about specific procs or sql fragments. Thanks again.