How do you use cloud databases? Take the survey.
Writing custom queries against repository for pulling SQL Monitor alert data
I'm trying to pull data from the repository about long running queries. To address the underlying problem, I need the SP name, function name, etc. from the process fragment. I'd like to be able to query this from the repository but I can't find the data I'm looking for. I realize the process fragment is probably BLOB but I can parse, etc. - I just can't find the table. Any thoughts of sample queries to allow me to pull date/time, query duration, and SQL process fragment for all alerts of a certian type?
0 · Share on Twitter