Dashboard of Different Custom Monitors

Greetings -

The server patching team is looking for a dashboard or dashboards to display some custom SAM monitors that monitor services to tell if they are up or down. 

We have an issue where we patch our SQL nodes and when they come backup up some of the SQL services are not started and that causes some issues with SQL.  I put together a SQL services monitor that monitors SQL Server Agent, SQL Server Service, and SQL Server VSS writer on all of our SQL nodes.  This is a bit of a starting point and we will be adding additional service monitors once we ID what services we need to monitor. 

Can I put together a dashboard of different monitors so the patching team can have this up when they are patching to verify that everything came up successfully?  This can be a classic or modern dashboard I am looking to put something together for this.  Ideally if someone can point me in the right direction I can start running with this once I know where to begin.

Thanks!


Dave

Parents
  • This will be straightforward to implement.

    1. Add to the page you wish to use for this user group the Custom Table widget
    2. Click Edit Data Source
    3. Change the I want to report on to 'Component'
    4. Add two filters which will only display SQL services with the component type being 1 meaning 'process'
      1. Name Contains SQL
      2. Component Type = 1      
    5. Give it a name and click update data source
    6. Now add your columns, for which you will want as a minimum
      1. Name (Add Details Page link in the Display settings
      2. Status
      3. You may also want to add other values

    I am not including all options and settings here, but this will give the basics of what you suggest you want.

  • So we are using the custom table to report on components that contain SQL in them via the data source picker.  Does that look correct below?

Reply Children