In SQL Monitor, I want to...

Specify a "details" query for custom metric

When I define a custom metric it would be super-helpful to be able to see some details that gave rise to the metric value. For example, I have one for "count of failed SQL logins in the last 10 mins". But to find out which logins failed, I have to go run queries in SSMS.

I'd like to be able to define a "details" query on the custom metric, the results of which are captured at time of collection, and are then available from the alert.

36 votes
Vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)
You have left! (?) (thinking…)
Murray shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

5 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Shay Saar commented  ·   ·  Flag as inappropriate

    When creating a custom metric, we usually want to get some additional data from the server, related to the alert. This data is often just plain text.

  • Asaf commented  ·   ·  Flag as inappropriate

    This is really a must have.
    Possible solution can be to allow second string column (in addition to the first scalar metric), so this string column value will be specified in the alert as the additional info.

Feedback and Knowledge Base