Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

Monitored connections in the deployment

Table 44: Spotlight on SQL Server is able to monitor the following connections

Connection type Requirements
SQL Server

Spotlight can monitor SQL Server instances of the following versions:

  • SQL Server 2016 (32-bit and 64-bit)
  • SQL Server 2014 (32-bit and 64-bit)
  • SQL Server 2012 (32-bit and 64-bit)
  • 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)

Spotlight on SQL Server 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 continues to monitor SQL Server 2000 instances Service Pack 3 or later, however no further support (fixes) will be provided.

Spotlight cannot monitor earlier versions of SQL Server (version 7.x and earlier).

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.

UDP port 1434 should be open. If UDP port 1434 is closed then the port number must be included in the address used to connect Spotlight to the SQL Server instance.

Database Cloud Service Spotlight can be used to monitor SQL Azure.
Windows Server

Spotlight can monitor the following operating systems:

  • Microsoft Windows 10 (32-bit and 64-bit)
  • Microsoft Windows 8.1 (32-bit and 64-bit)
  • Microsoft Windows 8 (32-bit and 64-bit)
  • Microsoft Windows 7 (32-bit and 64-bit)
  • Microsoft Windows Vista (32-bit and 64-bit)
  • Microsoft Windows Server 2012 R2 (64-bit)
  • Microsoft Windows Server 2012 (64-bit)
  • Microsoft Windows Server 2008 R2 (64-bit)
  • Microsoft Windows Server 2008 (32-bit and 64-bit)
  • Microsoft Windows Server 2003 (32-bit and 64-bit), however as this operating system is deprecated, WMI issues will no longer be investigated by support.

Spotlight requires the network setting "File and Print Sharing" to be enabled and any firewall configured to open TCP port 135.

Virtualization

Spotlight can monitor virtual environments and virtual guest machines in a virtual environment. The following is supported:

  • VMware ESX infrastructure. VMware vCenter 2.5 (or later). VMware ESX Server 4.0 (or later)
  • Hyper-V 6.2 and above.

The username used to connect to the virtual guest machine must have at least a read-only role.

Ensure any firewall is configured to open TCP port 135.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating