Schedule Top Queries

JonSko · April 27, 2017 10:53AM

Hi,

Is it possible to schedule a report of the Top Queries for a specific database?

Thanks
Jon

Adam W · May 2, 2017 8:44AM

Hi Jon,

The ability to run reports against particular servers is currently being developed. This would allow you to add, for example, the 'Longest running queries' tile to a report and schedule the report to run against specific server, but not a specific database. How far would this go to meeting your requirements?

Thanks
Adam

JonSko · May 2, 2017 1:49PM

Hi, yes that would be very helpful, what timeframe do you think this functionality would be released?

Adam W · May 4, 2017 8:59AM

We're hoping to release an initial version of it within the next couple of weeks (possibly in version 7.0.11)
I'll update you when it does get released

karl.oliver · July 11, 2017 10:00PM

was this done we are running Version: 7.0.14.8072

karl.oliver · July 12, 2017 3:22AM

i see reports feature is in Version: 7.0.14.8072

Adam W · July 12, 2017 11:32AM

Hi,

The ability to run reports against particular servers was released in version 7.0.11.

More improvements to the reporting are currently being developed and we hope to release them soon.

Thanks
Adam

JonSko · July 12, 2017 4:22PM

Hi, maybe I missed something but is it possible to email the reports and/or schedule the reports to be emailed on a daily/weekly basis ect?

karl.oliver · July 12, 2017 9:18PM

- yes it is possible the reports to be emailed on a daily/weekly

Adam W · July 13, 2017 5:38AM

Hi,

Currently you can schedule the reports to be emailed daily/weekly:
https://documentation.red-gate.com/display/SM7/Scheduling+emailed+reports

We are continuing to make improvements to the reporting, including making the scheduling more configurable.

Thanks
Adam

Schedule Top Queries

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk