SQL Monitor 12

Creating, configuring and downloading reports

What can be included in reports?

SQL Monitor supports four types of tiles that you can include in reports:

Summary tiles

These are a set of predefined reporting tiles:

  • Queries using most CPU worker time – Shows the longest running queries across your estate. 

  • Instances with lowest uptime – Shows the top 5 SQL Server instances with lowest uptime across your estate. 
  • Fastest filling disks – Shows the top 5 logical disks across your estate that are most likely to run out of space. 
  • Alert summary – Shows a breakdown of alerts for the current and previous periods by severity (High, Medium and Low) and alert type.
  • Server summary – Shows summary information about the SQL Server instance and host machine.
  • Server waits by day – Shows SQL Server waits for the top 5 SQL Servers with the highest cumulative waits over the report period. 
  • Logon failures – Shows the top logon failure messages recorded in the error log over the report period. 
  • Job  failures – Shows total number of job failures and most frequent job failures.
  • Server unreachable events – Shows total downtime for all and a breakdown of affected servers.

Analysis tiles

These tiles can be created from anything that can be shown in the Analysis graph (including custom metrics) over the time period of the report. See: Displaying metrics on the analysis graph.

Alert tiles

These tiles present a table of alerts using alert inbox filters from the alert inbox page. You can select the filter, the maximum number of rows to display, and whether to use the filter's time range or the report time range.

Deadlock tiles

These tiles present the top 5 deadlocks for either the whole estate or a chosen SQL Server instance

Creating a report

  1. Navigate to the Reports tab.

  2. Tap the button and the "Create Report" dialog should appear:

     

  3. Enter a report name and select whether you would like the report to be emailed automatically.

  4. Enter the recipients to whom you wish the report to be emailed.
  5. (Optional) Send a test email to check the validity.
  6. Select the period you would like the report to cover.

  7. Enter when you would like the report emailed to you, the frequency of the emails and the email recipients. See: Scheduling emailed reports for more information about emailing reports.

  8. Click the "Save" button.

Adding a chart/tile

  1. Tap the button and the "Add Tile" dialog should appear: 

  2. (Optional) Enter a custom title for the tile. 

  3. Choose the screen width of the graph. The following widths are available: 

    1. Full
    2. Three-quarters
    3. Two-thirds
    4. Half
    5. Third
    6. Quarter
  4. Choose the tile type. The following types are available: 

    1. Analysis graph
    2. Summary tile
    3. Alert tile
    4. Deadlock tile
  5. If the Analysis graph is chosen, select the metrics using the metric selector: 

  6. If the Summary tile is chosen, choose from the available summary tiles:

  7. Click "Add" to add the tile to the report. 

Editing, moving and deleting a chart/tile

  1. Click the  button at the top right of the tile. 

  2. A dialog menu should appear with the following options:

    1. Edit tile will bring up the edit dialog.

    2. Remove tile will delete the tile from the report.

    3. Move up will move the tile up one place.

    4. Move down will move the tile down one place. 

Editing, deleting and downloading a report

  1. Click the  button next to the report name selector.
  2. A dialog menu should appear with the following options:

    1. Edit report will bring up the edit report dialog. 
    2. Delete report will delete the current report and any associated email schedules. 
    3. Copy report to make a new report with a different name.
    4. Save as PDF will let you download the current report as a PDF. 

Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?