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

Shows information for each process running on the current system.

Members of the Spotlight Diagnostic Administrators group can end processes from the shortcut menu.

To view detailed information about a process, select a process in the grid.

To view the grid as a hierarchical tree, right-click the grid and select Show Tree.

Shows detailed information for the selected process.

To see the values for a statistic over the last hour, right-click a statistic shown in dark green and select Show History.

Shows the percentage of Privileged and User Time.

High Privileged time means that the program is predominantly busy accessing resources through operating system requests.

High User time means that the program is predominantly CPU-bound with the program code itself.

Reads / Second - Shows the number of IO reads (such as hard disk reads and memory reads) being performed by the process.

Writes / Second - Shows the number of IO writes (such as hard disk writes and memory writes) being performed by the process.

Shows the current memory allocated to the selected process.

Memory Usage shows the current size of the working set of the selected process. The working set is the set of memory pages touched recently by the threads in the process.

Virtual Memory Size shows the current size of the memory allocated to this process that cannot be shared with other processes.

Shows the number of page faults being generated by the program. A consistently high value may indicate a lack of memory. However, this collection includes both soft and hard page faults; as such, there may be no associated problems.

Shows current information about the threads executed by the selected process.

Shows details about the Windows services installed on the current system.

Click Start / Stop / Pause to change the running state of a selected service or device. You must be a member of the Spotlight diagnostic administrators group to change the running state. For more information, see Spotlight diagnostic user groups.

Right - click Select Process to locate the process running a selected share process.

Shows further details for the selected service such as a service description, the control accepted, and the executable.

Click an item in the grid to display service details.

Shows any services or drivers that must be running for the selected service to run. Stopping any of these services will also stop the selected service.

Double-click an entry to see its full details.

Shows any services that depend on the selected service running. Stopping the selected service will also stop these services.

Double-click a service to see its full details.

Shows details about the kernel drivers and file system drivers on the current system.