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!
Comments
5 comments
-
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
-
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!
-
Hi @Uri
Unfortunately, unless you're using Redgate Monitor Enterprise with the Rest API, we don't support writing queries out of the DB.
-
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.
-
Thank you!!!
Add comment
Please sign in to leave a comment.