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

Converse agora com nosso suporte

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

CPU % under Diagnose CPU doesn’t add up to the CPU% in Spotlight Home
Descrição

CPU % (Windows and SQL Server) under Diagnose CPU doesn’t add up to the CPU % in the Spotlight Home.
Resolução

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.
Informações adicionais

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.

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Conteúdo recomendado

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

Título