Chat now with support
Chat with Support

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

Windows Server


Spotlight displays for the Windows Server connection type

Select Windows from Monitored connections to show performance statistics for connections of type Windows Server.

Icon Help Reference Description
Heat map A display of monitored Windows Server connections focusing on those connections with the comparatively larger number and severity of alarms.
Spotlight today A display of Windows Server alarms raised, alarms are organized according to priority.
Alarms by time A display of Windows Server alarms raised, alarms are shown according to their duration and severity.
Alarm log A display of Windows Server alarms raised, alarms are sorted in a tabular format.


Spotlight displays for a single Windows Server connection

Expand the Windows connection type from Monitored connections to list connections by name.

Click on the connection name to show the Windows Server | Home Page for the connection.

Icon Help Reference Description
Windows Server | Home Page The Spotlight Home Page highlights obvious bottlenecks and problem areas. Statistics and flows are updated in real time.

Windows Server | Processes Drilldown Drilldown on running processes, installed services and installed drivers.

Windows Server | CPU Drilldown Drilldown on recent processor activity as measured by the Windows server.

Windows Server | Memory Drilldown Drilldown on recent physical and virtual memory usage.

Windows Server | Disks Drilldown Drilldown on the Windows server logical and physical disks.

Windows Server | Network Drilldown Drilldown on the network activity to and from the Windows server.

Windows Server | Events Logs Drilldown Drilldown on recent event log items. The Windows Event Log is where application or operating system information is written and can be accessed by system administrators.
Windows Server | Activity Drilldown Drilldown on summaries of recent activity on the Windows server.



Icon Description

Add and delete monitored connections. Change connection properties.

Configure the thresholds and severities that determine when alarms are raised.

Setup 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.

Schedule data collections.

Enter the scheduled maintenance times for monitored connections. Spotlight will treat monitored connections as unavailable at the scheduled times, so will not raise alarms or collect data during the outage period.

For monitoring connections to SQL Server and Windows servers, create and configure Custom Counters.

For monitoring connections to Windows servers, track the growth of certain (log) files.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating