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

EXAMPLE SOLUTIONS:
- 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)

236 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…)
    Daniel RothigDaniel Rothig shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Prasanth MatikanaPrasanth Matikana shared a merged idea: It would be nice if we are able to create scheduled reports and Emailed.  ·   · 
    Morten NilsenMorten Nilsen shared a merged idea: Embed analysis graphs in external website  ·   · 
    srikantsrikant shared a merged idea: overall daily health status report  ·   · 
    MartinMartin shared a merged idea: Profiler Export  ·   · 
    Dag CalafellDag Calafell shared a merged idea: KPI  ·   · 
    Blaž DakskoblerBlaž Dakskobler shared a merged idea: Wait stats - add a functionality for graphical analysis and comparison of historical data  ·   · 
    lprincelprince shared a merged idea: See graph/table of duration of LRQ over time for offending query(ies). This would allow me to get feedback to see if my fixes worked.  ·   · 
    Anonymous shared a merged idea: Alert and metric reporting  ·   · 
    Tony MaddonnaTony Maddonna shared a merged idea: Print reports of Alerts or provide Excel/DB export  ·   · 
    Derek GlickDerek Glick shared a merged idea: Allow the scheduling of analysis reports and send via email  ·   · 
    Matt CunninghamMatt Cunningham shared a merged idea: Allow customization of Analysis metrics export  ·   · 
    Eric HumphreyEric Humphrey shared a merged idea: show version  ·   · 
    BlueCollarCriticBlueCollarCritic shared a merged idea: Base Set Of Normalized Views For Custom Reporting  ·   · 
    Chris (Tech Support)Chris (Tech Support) shared a merged idea: BI interface for the SQL Monitor database  ·   · 
    Gail ShawGail Shaw shared a merged idea: Export the top 10 queries  ·   · 
    kevrileykevriley shared a merged idea: Show machine uptime  ·   · 
    planned  ·  Daniel RothigDaniel Rothig responded  · 

    We are working on a set of reporting scripts. For now, the views in the [data] schema are a good starting point.

    51 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...
      • AdamAdminAdam (User Experience Specialist, Red Gate Software) commented  ·   ·  Flag as inappropriate

        This is something we are currently considering how best to support. We'd like to understand a bit more about the requirements and get feedback on some possible solutions - anyone that would like to contribute, please email sqlmonitorfeedback@red-gate.com

        Meanwhile, I'll merge this with the main reporting suggestion so we can keep track of different requirements.

      • 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.

      • Tony MaddonnaTony Maddonna commented  ·   ·  Flag as inappropriate

        There are no real reporting functions in SQL Monitor. We have a need to print reports based on the Alerts we are receiving and distribute them amongst the appropriate Application Managers/Developers for correction to code. At this time all that can be done is a screen scrape. There has to be reporting functions of the alerts, with details so they can be remedied by other parties than those monitoring the systems.

      • HemiHemi commented  ·   ·  Flag as inappropriate

        Yes. We have this for our Legacy systems and it would be great to have this for SQL Monitor monitored systems. This is the one key thing that SQL Monitor is missing.

      ← Previous 1 3

      Feedback and Knowledge Base