Supply SQL Server instance connection details to Spotlight Cloud.
Spotlight Cloud Help
In some environments, it may not be feasible for Spotlight Cloud to connect to the 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 instances and SQL Server connections hosted on Unix/Linux.
Drilldown on deadlocks. A deadlock occurs when multiple processes are competing for exclusive access to a resource. This results in a standoff where no process can proceed. To alleviate the deadlock, one of the sessions is selected as a deadlock victim and its current transaction is rolled back. When this occurs, all of the locks held by the victim’s session are released, allowing other previously blocked sessions to continue processing.
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.
Drilldown on the availability of a SQL Server instance, its databases and SQL Server services.
Drilldown on key system health issues. Pinpoint and address these issues within your SQL Server infrastructure.
List the alarms that can be raised against the SQL Server instance connection.