Supply SQL Server on-premise connection details to Spotlight Cloud.
Spotlight Cloud Help
In some environments, it may not be feasible for Spotlight Cloud to connect to the on-premise SQL Server instance with an account that is a member of the sysadmin server role. The following instructions are provided for these environments.
Spotlight Cloud provides partial support for monitoring SQL Server 2017 connections and SQL Server connections hosted on Unix/Linux.
Drilldown on I/O statistics for each SQL Server database file.
Drilldown on usage of the TempDB system database. TempDB is a temporary workspace for storing temporary tables that hold intermediate results during sorting or query processing. Tempdb is re-created newly from stored configuration each time the SQL Server service starts.
List the alarms that can be raised against the SQL Server connection
Drilldown on the availability of a SQL Server instance, its databases and SQL Server services.
Connect on-premise SQL Server instances fulfilling the following requirements to Spotlight Cloud.
Drilldown on key system health issues. Pinpoint and address these issues within your SQL Server infrastructure.