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

Monitored Windows Servers and hosts of database connections

Monitoring Windows Servers and hosts of database connections

The Spotlight Diagnostic Server uses WMI queries to retrieve performance counter information from monitored Windows Servers and Windows hosts of database connections. This data is then displayed in real time on a Spotlight Client or other Spotlight viewer (View data and configure Spotlight).

Windows Server | Connection Details

Open this screen from the Spotlight Client

  1. Click Configure | Connections.

  2. Select the Windows connection type.
  3. Click Add a new connection or to edit, right click the connection and select Properties.

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

Specify the operating system connection details

Field Description

Address

The IP address, hostname, or URL of the Windows Server.

If the Windows Server is in a different domain to the Spotlight Diagnostic Server host then specify the address as a fully qualified address (for example, machine1.domain.company.corp). The connection may work intermittently if the address is not fully qualified.

Spotlight can only connect to Windows servers in a domain. Spotlight cannot connect to Windows servers in a workgroup. Spotlight cannot connect to databases hosted on Windows servers in a workgroup.

Authentication

The authentication for Spotlight to use to connect to the Windows server.

Select Use Diagnostic Server credentials to use the Windows user configured to run the Spotlight Diagnostic Server. You are required to select this option for the Windows Server that hosts the Spotlight Diagnostic Server. If you select this option and the Windows Server is remote from the Spotlight Diagnostic Server then ensure the Windows user running the Spotlight Diagnostic Server can access the Windows Server. (By default the Spotlight Diagnostic Server runs under the "Local System" account, which will not have privileges on a remote Windows Server). If you select this option and the Windows Server is in a different domain from the Spotlight Diagnostic Server then ensure the domain the Windows Server is in trusts the domain of the user running the Spotlight Diagnostic Server.

Alternatively, fill in the User and Password fields. Include the Windows domain in the user name. For example, “domain\johnsmith”, instead of “johnsmith”. The account must have the privileges required to retrieve server information, query the registry, and access WMI and performance monitor objects. An account with administrative rights to the Windows server allows this. Alternatively an account can be configured with the necessary privileges as per How to configure WMI with minimum required user permissions.

Virtualization details

Field Description

Connection

If this Windows server is hosted by a virtual server then select the name of the virtual server.

TIP: Click Create to add a virtual server to the list.

VM Name

Select the name of the virtual machine from those hosted by the virtual server.

 

TIP: When done, click Test to verify Spotlight can successfully establish a connection with the details provided. If there are connection problems see Monitoring Windows Servers and hosts of database connections.

Monitoring Windows Servers and hosts of database connections

Monitored Windows Servers and hosts of database connections > Monitoring Windows Servers and hosts of database connections

Table 21: Connection to the Windows Server (SQL Server host)

Section Description

Windows Server | Connection Details

Use a Spotlight Client to create a connection from the Spotlight Diagnostic Server to the Windows Server (host of the database connection).

If the Windows Server is in a different domain to the Spotlight Diagnostic Server host then ensure the address provided is fully qualified (for example, machine1.domain.company.corp). The connection may work intermittently if the address is not fully qualified.

Windows Domains

Spotlight can only connect to Windows servers in a domain. Spotlight cannot connect to Windows servers in a workgroup. Spotlight cannot connect to databases hosted on Windows servers in a workgroup.

Windows Account Permissions

Spotlight requires authentication to connect to the Windows server and retrieve performance data. There are two ways to do this at Windows Server | Connection Details: use Diagnostic Server credentials or fill in the user and password fields.

When Use Diagnostic Server credentials is selected, Spotlight uses the Windows user configured to run the Spotlight Diagnostic Server. Selecting this option is required to connect to the Windows Server that hosts the Spotlight Diagnostic Server. If you select this option and the Windows Server is remote from the Spotlight Diagnostic Server then ensure the Windows user running the Spotlight Diagnostic Server can access the Windows Server. (By default the Spotlight Diagnostic Server runs under the "Local System" account, which will not have privileges on a remote Windows Server). If you select this option and the Windows Server is in a different domain from the Spotlight Diagnostic Server then ensure the domain the Windows Server is in trusts the domain of the user running the Spotlight Diagnostic Server.

Alternatively, fill in the User and Password fields. Include the Windows domain in the user name. For example, “domain\johnsmith”, instead of “johnsmith”. The account must have the privileges required to retrieve server information, query the registry, and access WMI and performance monitor objects. An account with administrative rights to the Windows server allows this. Alternatively an account can be configured with the necessary privileges as per How to configure WMI with minimum required user permissions.

Troubleshooting WMI

The Spotlight Diagnostic Server uses WMI queries to retrieve performance counter information from the Windows Server. If there are problems, you may want to verify WMI is working and returns data properly.

Verify TCP port 135 is open on the Windows server.

Table 22: Collect and display data and user actions

Section Description

Execute user actions on the Windows Server from the Spotlight Client

In order to execute actions on the Windows Server (like kill a session) from the Spotlight Client, the Windows user running the Spotlight Client must be a member of at least one of the Spotlight diagnostic user groups.

Data display and collection problems - Windows Server connection

Ensure necessary components are enabled on the Windows Server (SQL Server host) to ensure correct data display and collection.

Troubleshooting

Check the Known Issues section of the Spotlight on SQL Server Release Notes.

How to configure WMI with minimum required user permissions

Monitored Windows Servers and hosts of database connections > How to configure WMI with minimum required user permissions

Spotlight requires authentication to connect to the Windows server and retrieve performance data. There are two ways to do this at Windows Server | Connection Details: use Diagnostic Server credentials or fill in the user and password fields. If you choose to fill in the user and password fields, the account must have the privileges required to retrieve server information, query the registry, and access WMI and performance monitor objects. An account with administrative rights to the Windows server allows this.

In some environments it may not be feasible to connect to the Windows server with an account that is a member of the Administrators group. The following instructions are provided for these environments. Note that there are known issues with this procedure as documented below.

1. Setup permission to read data

2. Grant permissions to get information about services

3. Provide access to the Registry keys used by Spotlight

4. Run Windows Component Services

5. Configure WMI permissions

Following are known issues with configuring WMI with minimum required permissions

Known Issue Description

The OpenSessions collection

The OpenSessions collection sends a list of the open Windows network sessions to your server. The list includes who is connected and from where, how long they have been connected and how many files they have open.

The OpenSessions collection is used in:

  • The Windows Server | Home Page | Network panel | Open Sessions count.
  • The Network Drilldown | Sessions page.

Spotlight does not alarm on this data.

The Physical Disk Drive collection

The Physical Disk Drive collection populates the Disks Drilldown | Disk Summary page. This drilldown contains a list of the physical disks installed on the server. Its data is relatively static as it only changes when disks are added, removed or repartitioned.

Inside of this known issue a Generic Failure error will be returned.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating