CPU % under Diagnose CPU doesn’t add up to the CPU% in Spotlight Home (4280023)

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

CPU % under Diagnose CPU doesn’t add up to the CPU% in Spotlight Home
Descripción

CPU % (Windows and SQL Server) under Diagnose CPU doesn’t add up to the CPU % in the Spotlight Home.
Resolución

CPU in home page and Windows CPU in Diagnose CPU page are from the same data source and they include all Windows processes including SQL Server.
The SQL Server CPU value under Diagnose CPU is driven by current CPU usage for Sql Server process only.
Also please note that this drill down is not automatically refreshed.
Información adicional

Windows CPU and SQL Server CPU are two separate calculations. Windows CPU usage value comes from windows WMI class Win32_PerfRawData_PerfOS_Processor. It is a moving average of the last 5 samples of the percentage usage of all processors. SQL Server CPU present comes from SQL Server DMV sys.dm_os_threads. It is a rate value between last and current SQLCPU.UsageTime. It is based on data taken from SQL Server.

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Producto(s):: Spotlight on SQL Server Enterprise
11.0, 10.5.2, 10.5.1, 10.5, 10.0.2, 10.0.1, 10.0

Historial del artículo:: Creado el: 11/19/2014
Última actualización: 5/7/2023

Título