Monitor SQL Server Aspects on SolarWinds

CjWig

SQL Server Jobs

Does anyone have any suggestions on how we monitor our SQL server jobs on SolarWinds or if this is even anything SolarWinds can do?

We have multiple jobs which run and can fail due to lack of memory we would like a dashboard or report on SolarWinds which would show us the status of the job and its last 10 job history events to show if it has run successfully since the failure rather than remoting into the server and digging about.

SQL Server Backups

Is there a way to get a report of the last date/time a SQL server had backup/logs made? I have checked the prebuild reports in SolarWinds and can't find anything which fits

SQL Server service start-up/shutdown repot

Is there a way to get a report to show the start-up and shutdown data for all SQL servers? Once again I have checked the prebuild reports in SolarWinds and can't find anything which fits

 

KMSigma.SWI

These options are part of the [mention:a84e186fd01942edab9c43c038b14c6c:23b05a61c3e5445190d9bfa00453bce4] platform out of the box.

Jobs: SolarWinds Hybrid Cloud Observability Demo | SolarWinds Demo - AppInsight for SQL - Summary - MSSQLSERVER (in the bottom-right)

Backups: SolarWinds Hybrid Cloud Observability Demo | SolarWinds Demo - SQL Database - Summary - Search_Service_Application_DB_28781403274b49408ce169c440698563 (in the top left)

Service Management is a built-in part of the platform.