Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Deployment Guide

Welcome to Spotlight on SQL Server The size and shape of your deployment Install / Upgrade Spotlight data collection and storage View data and configure Spotlight Monitored connections in the deployment Deployment over the Windows network Monitored SQL Servers Monitored Windows Servers and hosts of database connections

Spotlight Mobile

Monitor Spotlight connections on a mobile device.

Monitoring features include a heat map, alarms list and alarm details and the ability to snooze and acknowledge alarms.

The Spotlight Mobile app is available for native Windows 8, Windows 8 Phone, iPad, iPhone and android app. For more information see www.spotlightessentials.com.

Configuration

  1. Create a Spotlight Cloud (Spotlight Essentials) account if you do not already have one. Do this at www.spotlightessentials.com.
  2. Use a Spotlight Client to Configure uploading to Spotlight Cloud.
  3. Download and Install Spotlight Mobile from www.spotlightessentials.com.
  4. Sign in to Spotlight Mobile with your Spotlight Cloud account. If you have many Spotlight Cloud accounts then each can be added to Spotlight Mobile.
  5. You may be given the opportunity to decline to receive push notifications from Spotlight on this mobile device. For information on push notifications, see the online help. For information on the receipt of these push notifications, refer to the Spotlight Mobile User Guide.

Deployment

Spotlight Diagnostic Server

Data is uploaded from the Spotlight Diagnostic Server to Spotlight Cloud to Spotlight Mobile. Ensure the Spotlight Diagnostic Server has access to the Internet. For more information, see Spotlight services requiring Internet access.

Playback Database

Use a Spotlight Client to configure the Playback Database for the Spotlight Diagnostic Server. Spotlight Mobile cannot be used to configure the Playback Database.

Spotlight Statistics Repository

Use a Spotlight Client to access the Spotlight Statistics Repository. Spotlight Mobile has no access to the Spotlight Statistics Repository.

Monitored connections in the deployment

Use a Spotlight Client to manage the connections monitored by the Spotlight Diagnostic Server. Spotlight Mobile cannot be used to manage Spotlight connections.

Monitored connections in the deployment

Monitored connections in the deployment

Table 17: 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.

Configure

Configure Spotlight from the Spotlight Client Configure ribbon.

Icon Ribbon Select Description

Connections

Manage the connections monitored by Spotlight.

Alarms

Set the thresholds and severities that determine when an alarm is raised. Disable an alarm. Set an alarm to require acknowledgment. Configure keyed alarms. Collect additional diagnostic information on an alarm.

Alarm Actions

Set actions for Spotlight to take when an alarm is raised. The actions Spotlight can take include running a program and sending an email. Conditions on taking the action can be defined, such as the day of the week, the time of day, the severity of the alarm, the alarm type and the connection type.

Scheduling

Spotlight collects data according to these set schedules.

Planned Outage

Enter the scheduled maintenance times for the connections Spotlight monitors so Spotlight does not raise alarms and attempt to collect data during the outage period.

SQL Analysis

Enable SQL Analysis. Configure the filters used to gather SQL Analysis data.

SQL Server Response Time

Set the SQL statement that is used to measure SQL Server response time.


Custom Counters

Create and configure Custom Counters for monitoring connections to SQL Servers and Windows servers.


Error Log Entries

Request Spotlight raise an alarm when a specified entry is logged in the SQL Server error log.

Monitored Files

Track the growth of specified files (usually log files) on monitored Windows Servers.

Spotlight

Customize the Spotlight Client look and feel. Configure operations for the Spotlight Diagnostic Server.

Diagnostic Server

Configure operations for the Spotlight Diagnostic Server.

Spotlight Cloud

Enable functionality to monitor Spotlight connections from the Spotlight web site or Spotlight Mobile. Upload performance data for health check analysis.

User Experience

Influence the design of future versions of Spotlight and help us improve its quality, reliability and performance.

Configure | Connections

Spotlight connects to the SQL Server, Windows Server and other supported connection types in your enterprise. Spotlight monitors the activity and performance of these connections. Use this screen to add and remove connections and configure connection properties.

Open this screen from the Spotlight Client

Click Configure | Connections.

Click Add a new connection

Connection type Description

Analysis Services

SQL Server Analysis Services servers.

Availability Groups

Always On Availability Groups. An availability group is a set of user databases that fail over together.

Hyper-V

Virtual machines on a Hyper-V server.

Replication

SQL Server Replication environments.

SQL Azure

SQL Azure databases.

SQL Server

SQL Server instances. (SQL Server | Connection Details)

VMware

Virtual machines on a monitored VMware server.

Windows

Windows Servers including hosts of database connections. (Windows Server | Connection Details)

 

TIP: Spotlight can add SQL Server instances and Windows Server via discovery or by importing details from a file.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating