SQL Instance report using Redgate.

• pols

  SSC Eights!

  Points: 935

  More actions

  March 12, 2019 at 2:28 am

  #379966

  Hi,

  I am new to Red gate monitoring tool.
  I need to give below reports for SQL Instance using red gate.
  Can you 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|

  Thanks in advance.

  Jo

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  March 12, 2019 at 6:28 am

  #2024200

  You're going to have to hit the tables and create a manual report (using Reporting Services, PowerBI or something) to pull all that together into a single report. Some of it isn't capture by SQL Monitor. Database Parameters for example, I think you mean Database Properties right? There isn't anything in SQL Monitor that gathers that data. Same goes for Server settings and configuration changes. For the security settings and changes, you'll need to add a custom metric.

  All the rest of the data is available, not in a pre-canned report. This will get you going with customized reporting if you really need to put it all together in a single view. Also, take a look at the Reporting page. You can add a page and then plug in the metrics that you like, memory consumed, alerts, whatever. You'll see a couple of example reports already there.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning