I suggest you ...

Disk Space / tempdb / Custom Alerts

Hi,
I have couple of suggestions as per my present system architecture ...
1) For disk space alerts, user should be able to configure this alert for as many disk/drives as user wants out of the total disks/drives are available on the server. If needed, user should also be able to ignore a particular drive. Right now, SQL monitor checks for all the disks/drives on the server
2) For database level alerts, there should be a exclusive alert for tempdb space
3) In custom alerts, SQL Monitor should be able to display a resultset of a SQL query and publish that report
E.g. sp_who2 returns a tabular resultset. user should be able to configure these type of reports in SQL monitor

Please let me know if there already is a workaround for this.

5 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Swapnil ManglekarSwapnil Manglekar shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Swapnil ManglekarSwapnil Manglekar commented  ·   ·  Flag as inappropriate

        Also, we have configured "Job duration unusual" alert for the DB servers we have.
        So, we want to know if the below given report can be accomplished thorugh SQL Monitor -

        Server name
        Query (HTML encoded)
        Client dab
        Current duration (query response times)
        Last Duration
        Average Duration
        90th Percentile ranking (this basically says which query is worse than this one)
        80th percentile
        ...
        10th percentile

        Is it possible using any other alerts (may be custome alert) ? Kindly let us know.

      Feedback and Knowledge Base