Chat now with support
Chat with Support

Spotlight on SAP ASE 2.11 - User Guide

Spotlight on SAP ASE
Background Information Desktop Features Connect to SAP ASE Spotlight® on SAP ASE Drilldowns Spotlight® on SAP ASE Alarms Glossary
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Issues Monitoring A Windows Machine

Spotlight on Windows

Spotlight is a powerful diagnostic and problem-resolution tool for Windows operating systems. Its unique user interface provides you with an intuitive, visual representation of the activity on the host machine.

For information on Spotlight on Windows, see these sections



Background Information

Introductory material to Spotlight on Windows.

Connect to a Windows System Create / Modify / Delete connections to Windows systems.
Home Page The Spotlight home page shows the flow of information and commands between various sub-components and the size and status of internal resources such as processes, disk files and memory structures.

Spotlight alerts you to problems with your system by issuing an alarm. You can configure Spotlight in the level of severity that constitutes an alarm, to disable an alarm, and the actions Spotlight takes on raising the alarm.

Drilldowns When you have isolated a problem, you can display a drilldown page, whose charts and tables provide a detailed breakdown of the underlying statistics.
View | Options Customize Spotlight.
Troubleshooting Solve problems using Spotlight.

For information on using Spotlight applications See

Spotlight Basics


Display Problems on The Home Page Disks Panel And Disk Drilldown

The Disks panel on the Spotlight on Windows home page and the Disks drilldown are not displaying data. Ensure disk performance counters are enabled on the Windows machine being monitored.

Solution: Enable collection of disk data:

On the Windows system being monitored

  1. Start a command line window
  2. At the command prompt, type the following

    diskperf -y

  3. Restart the system.


Related Topics

Disk Summary Page

Display Problems on The Home Page Network Panel, Flows And Network Drilldown

Spotlight on Windows cannot display data in the Network panel, flows, and drilldowns. The likely cause is that the appropriate performance counters have not been enabled on the Windows machine being diagnosed.

Solution: Enable the collection of network data:

  • Check that the PerfNet counters are active on the system. To do so, use the Exctrlst utility, which you can download from the Microsoft Web site.
  • Check that at least one network device is using NBT (NetBIOS over TCP/IP). To do so, check the properties of all network connections (in particular, Advanced TCP/IP Settings | WINS) to ensure that the NetBIOS setting is not disabled.
  • Check that Service Pack 4 is installed on Windows 2000 systems.


Related Topics

The Processes Page And Process Affinity

In Windows systems where there are multiple processors, an activity (thread) in a process can migrate from processor to processor – and every migration reloads the processor cache.

Process affinity, which you can set on the target Windows machine via the Windows Task Manager, allows you to establish an association that permits specified processes to run ONLY on nominated processors. This limits the number of cache reloads, which may be desirable on systems operating under heavy load.

You CANNOT set process affinity via Spotlight on Windows.

What you CAN do is:

Use the Processes drilldown to indicate the CPUs where the specified process is permitted to run. This enables Spotlight to report the CPU usage for that process with accuracy.

Example: Running a process on an eight-CPU system

Spotlight uses the Windows Performance Monitor (PerfMon) to retrieve important data from target Windows systems, including the total percentage of CPU usage by specified processes.

On a single-CPU system, PerfMon can report a maximum CPU usage of 100%.

On a multiple-CPU system, that maximum value is multiplied by the number of CPUs. For an eight-CPU system, PerfMon can report a maximum CPU usage of 800%. Spotlight on Windows compensates by dividing the reported PerfMon value by the number of CPUs on the system.

However, when the affinity for a process is set so that it can run only on two nominated CPUs of the eight available, the default Spotlight calculation fails. For example, if PerfMon reports a CPU usage of 120% for the process (corresponding to a 60% usage on each permitted CPU), Spotlight initially calculates a value of 15%. Use Spotlight's Configure Affinity function to adjust the Spotlight calculation. Processes Page

How to set process affinity

Process affinity can be set via the Windows Task Manager on Windows machines that have multiple CPUs.

  1. Log in to the monitored Windows machine.
  2. Press CTRL+ALT+DEL.
  3. Click Task Manager | Processes.
  4. Right-click the name of the process whose affinity you want to set and select Set Affinity.

    Note: This option is unavailable when the system has one CPU.

  5. Select which of the available CPUs you want to use for the process.

Note: You can also set process affinity for Microsoft SQL Server through the SQL Server Enterprise Manager.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating