In SQL Monitor, I want to...

Custom reports against alerts, queries and metrics

CONTEXT: We want to see the bigger picture arising from the data presented in SQL Monitor.

PROBLEM: Currently you can't pull together a report in the SQL Monitor UI, and the monitoring database is not particularly accessible. We need reports against:
- The metrics shown in the analysis graph
- The top queries and waits
- The alerts raised over time
- Server configuration and SLA

- Provide reporting scripts against the monitoring database
- Privide a BI interface against the monitoring database
- Priovide richer data-export functionality in the UI
- Provide a report designer in the UI (perhaps allowing for regular reports to be sent)

248 votes
Sign in
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Daniel RothigDaniel Rothig shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdamAdminAdam (User Experience Specialist, Red Gate Software) responded  · 

    Version 6.0.17 of SQL Monitor has been released and features enhancements to the reporting beta, now allowing you to make a copy of a report. Version 6.0.16 previously added a new summary tile for Server Waits by day and made improvements to the scheduling.

    If you have any further feedback or details about your specific requirements, please comment or email so that we can consider them as we continue to develop the feature.

    Thanks, Adam


    Sign in
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      • Blaž DakskoblerBlaž Dakskobler commented  ·   ·  Flag as inappropriate

        Already emailed these, but posting here as well:
        - I suggest you add more periods (1 hour, 3 hours, 6 hours).
        - Reports are now static. A switch to enable/disable auto refresh of the report would be nice – as in, if you want to use it as a dashboard on some big screen. Example: report for last X hours, but you want the charts to always show time up to the present moment. Report refresh frequency is debatable… perhaps make even that a choice, per report (every 10 seconds, every X minutes…).

      • mschiermschier commented  ·   ·  Flag as inappropriate

        I have some feature requests for the new reports function in sqlmonitor (

        - copy reports: usecase – is define a report for a server + copy this report for other servers
        - view time: please make this filed as free definable – usecase – create reports for an whole month, not last 27 days
        - disk avg. read/write: I want to choose the scaling by my self – usecase – to ignore a spike
        - disk avg. read/write: please specify the term TimeSpan on the ordinate with seconds, millisecond

      • KonstantinKonstantin commented  ·   ·  Flag as inappropriate

        It will be great if there was instead of top 10 worst performing query top 50 for example and choose a query/SP and check what was the difference today compared to 2 months back in the time in term of duration and some wait stats. + the scheduled report to be sent via email in PDF or HTML format. As well apart from Availability Groups no other DR metrics are available custom or build in (Replication,Mirroring,LogShipping)

      • Morten NilsenMorten Nilsen commented  ·   ·  Flag as inappropriate

        Is there a way to embed one of these report tiles in a custom dashboard?
        I currently load MRTG Weathermap images and splunk reports as iframes into a simple webpage that I have open on an overhead screen to monitor our systems. I would love to get SQLMonitor up on this screen as well.

      • Prasanth MatikanaPrasanth Matikana commented  ·   ·  Flag as inappropriate

        Generate scheduled reports on every added instance.
        For example: A weekly health report or Weekly long running query report or monthly Database growth report etc.

      • Garry ArmourGarry Armour commented  ·   ·  Flag as inappropriate

        Hi, I have a quick comment to make on this request.

        I have a situation where I need to demonstrate an improvement or drop in number of deadlocks, blocked processes, long running, etc... over time

        So, for example, an increase in CPU count on an SQL server has had a marked improvement on the performance but I cannot export any alerts from SQL Monitor to show this.
        Ideally, an ability to export the alerts based on the current filter would be very useful. csv, excel, whatever.

      • Morten NilsenMorten Nilsen commented  ·   ·  Flag as inappropriate

        For building a global monitoring dashboard, I would like the ability to set up an analysis graph and embed it as an image from a different webpage.
        Some way to embed basic stats/alert counters and the like would also be handy.

      • srikantsrikant commented  ·   ·  Flag as inappropriate

        I would love to see a enhancement for sending out an automated mailer daily/customized schedule for giving a report for each and every server with common important metrics to analyze the server health on email without need to login into RedGate.

      • MartinMartin commented  ·   ·  Flag as inappropriate

        When running trace through redgate can you add the option to export the profile so when I click on a spid I can export the trace as you can copy the whole content.

      • Dag CalafellDag Calafell commented  ·   ·  Flag as inappropriate

        I'd like a KPIs area. For example:

        Number of Occurrences above 60% CPU: 193
        Average Duration of an Occurrence over 60% CPU: 68 Seconds
        Number of Occurrences above 60% CPU which lasted longer than 3 minutes: 10
        Total time spent above 60% CPU: 221 Minutes
        Longest occurrence above 60% CPU: 30 Minutes

        Same for page splits, PLE, et cetera

      • HemiHemi commented  ·   ·  Flag as inappropriate

        This would be a GREAT feature to add. My boss wants to see how our SQL Servers are performing CPU and disk utilization wise on a weekly basis.

      • Blaž DakskoblerBlaž Dakskobler commented  ·   ·  Flag as inappropriate

        In v4.0 wait stats analysis was added on the overview pages. I'd like to see that extended to the point where we'd be able to graphically analyse historical data about wait stats, similar as metric analysis on the Analysis tab. Baselines and comparisons included.

      • TomTom commented  ·   ·  Flag as inappropriate

        Yes, it would be great to have the ability to export a single alert from the alert details page. It would also be great to be able to export the whole ball of wax...

      • dandan commented  ·   ·  Flag as inappropriate

        When receiving email alerts for slow running queries, it would be valuable (more and more so) to have an HTML page with an Export to XLS option, showing the alerts received via email and any/all associated metrics with the slow running queries.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I like to take a summary of alerts over a definable period by server, instance, database. This will help me monitor error rate. A facility to present this graphically would be fantastic.

      ← Previous 1 3

      Feedback and Knowledge Base