Allow the scheduling of analysis reports and send via email
The analysis reports should be able to run on a schedule and send the via email. For instance it would be great if I could schedule the data/log size report to run every monday and send me the results via email. the ability to export these report to excel is already there, so just needs to be able to run on a schedule and send as an email attachment.
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.
Thanks a lot to all of you for your suggestion.
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.
Matt Laffoon commented
I'm a big fan of ideas like this. I would like to see more *built-in* analysis as a whole. I'll add one piece to this... the ability to archive these reports for a configurable period separate from the period of time all of the detailed data is stored for.
Obviously it's possible for DBAs to create this on their own by pushing data to other databases, creating or installing reports (I know Red Gate provides a few SSRS reports) in reporting services and scheduling the email from there. That solution is fine, except I doubt the DBAs that purchase SQL Monitor are the type that have excessive free time to create tools on their own. I'm a fan of Red Gate tools because they allow DBAs to focus on the core of their job by creating complete DB tools so we don't have to. :)