SQL Reports using Redgate

Jo1

Hi,

I am new to Red gate monitoring tool.
I need to give below reports for SQL Instance using red gate.
Can anyone please guide me how to do that.

||Audit Server Specification Changes (CPU, RAM, IP)|
||Audit Database Metrics and Configuration changes|
|•|Database Parameters|
|•|Policy and Security validations |
||Alerts |
||Response Time|
||Number of active users|
||Uptime|
||Backups |
||Top tables|
||Memory Consumed|
||Hit Ratios |
||Performance (Full Scans, Locks, Latches) and Long Queries|
||Maintenance Jobs (Index and Statistics, …)|
||MDF/LDF Sizes and Maintenance|

Russell D

Try https://documentation.red-gate.com/sm9/reports/scheduling-emailed-reports.

Russell D

Here's a good starting point for creating reports: https://documentation.red-gate.com/sm9/reports/creating-configuring-and-downloading-reports.

Jo1

Thank you very much. I created the reports manually. Is their any way to generate automatic reports every month ?

Jo1

Yes..I got it. Thank you very much.. Can you guide me how to track report for no of active users on SQL & performance (full scan,locks,latches) .