Comments
4 comments
-
Here's a good starting point for creating reports: https://documentation.red-gate.com/sm9/reports/creating-configuring-and-downloading-reports.
-
Thank you very much. I created the reports manually. Is their any way to generate automatic reports every month ?
-
-
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) .
Add comment
Please sign in to leave a comment.
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|