Spotlight can monitor SQL Server instances of the following versions, editions Enterprise, Standard and Express:
- SQL Server 2022 (64-bit)
- SQL Server 2019 (64-bit)
- SQL Server 2017 (64-bit)
- SQL Server 2016 (64-bit)
- SQL Server 2014 (32-bit and 64-bit)
- SQL Server 2012 (32-bit and 64-bit)
The Spotlight Enterprise customer support will not be available for the following SQL servers as Microsoft has stopped providing support for these platforms. However, Spotlight Enterprise will continue monitoring the SQL servers added.
- SQL Server 2008 R2 (32-bit and 64-bit)
- SQL Server 2008 (32-bit and 64-bit)
- SQL Server 2005 (32-bit and 64-bit)
Partial support is provided for monitoring SQL Server 2017 and above hosted on Linux. For more information on monitoring SQL Server connections on Linux hosts, particularly SQL Server 2017 and above connections, see: Partial support for monitoring SQL Server: SQL Server 2017 and above hosted on Linux.
Spotlight Enterprise also supports MSDE (2000), SQL Express (2005) and SQL Server 2008 Express Edition. Note that use of these versions to host playback or Spotlight Statistics Repository databases is not supported.
Spotlight cannot monitor earlier versions of SQL Server (SQL Server 2000 and earlier). Spotlight does not support Database Compatibility Level: SQL Server 2000.
Spotlight supports all SQL Server sort orders, including case-sensitive and binary sort orders. Spotlight cannot monitor SQL Server instances where the instance name contains non-US ASCII characters.
On each monitored instance Spotlight requires the network setting “File and Print Sharing” to be enabled.
If the SQL Server instance is hosted on a Windows server and UDP port 1434 is closed then the port number must be included in the address used to connect Spotlight to the SQL Server instance.