Chat now with support
Chat with Support

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

SQL Server | Home Page | Processes Panel

The Processes panel provides access to, and information about, the following:

Component Description

Total

Shows the total number of SQL Server sessions (SPIDs). It includes both user and system sessions.

System

Shows the total number of current SQL Server System sessions (SPIDs).

This includes any sessions from SQL Server system processes such as the Checkpoint, LogWriter and LazyWriter processes etc., as well as various SQL Server Agent system processes (Alert Engine, Email Logger etc.).

User

Shows the total number of current User (non-system) sessions, excluding SQL Server Agent sessions.

Blocked Processes

Shows the number of sessions that are waiting on locks held by others.

Virtualization Overhead

In a virtual environment the physical CPU of a host is shared by virtual machines and the hypervisor. Multiple processes may want to use the physical CPU of the host at the same time. The virtual machines may have to wait to be scheduled on a CPU.

Display Description

Gauge

Show the percentage of CPU that is unavailable to this virtual machine because it is being consumed either by other virtual machines or by VMware itself. The amount of ready time is shown as a percentage of the theoretical maximum CPU available to the virtual machine.

Applicable to Windows Servers hosted on VMware.

Wait Time in nanoseconds

Show the average time the virtual machine spent waiting for CPU over the collection interval (average 5 minutes). The average wait time should remain under 60,000ns. If the average wait time exceeds 60,000ns then a Hyper-V CPU wait time per dispatch alarm is raised. A high alarm is raised if the average wait time exceeds 100,000ns. See also Windows Server | CPU Drilldown

The Hyper-V - Virtual Overhead alarm is raised on excessive CPU being used by the hypervisor on this virtual machine.

Applicable to Windows Servers hosted on Hyper-V.

Not Virtualized

The Windows Server is not hosted on a virtual machine or the virtual machine is unknown. For more information, see Windows Server | Connection Details.

CPU Usage

Represents the total amount of CPU being used on the Windows server. It includes CPU consumed by all Windows processes, not just SQL Server.

This component spins faster as CPU demands increase.

 

Data Flows

Component Description

Logical Read/s

This flow from the Memory panel to the Processes panel shows the rate at which pages in the Buffer Cache are being referenced by SQL connections (logical page reads). 

Normally, the majority of Logical Reads will be satisfied from the cache, but if the required page is not already there, it will be read from disk.

Compiles/s

This flow from the Processes panel to the Memory panel shows the rate of SQL compilations and re-compilations.

All SQL statements need to be compiled by SQL Server before they are executed. Compiling is the process by which SQL Server converts the SQL statement into an executable query plan.

Under certain circumstances, SQL Server will re-compile SQL statements.  Recompiling can consume a large amount of CPU, and can degrade performance.

Sound coding practices, such as using Stored Procedures and parameterizing queries, can help to reduce recompiles.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating