Skip to content

System Threads/Commands CPU Utilization report seems to show inflated CPU utilization likely not considering CPU count on the system #457

@PiJoCoder

Description

@PiJoCoder

When looking at the %CPU utilization for system requests in Nexus, the values shown do not take into account the # CPUs on the box. Therefore values displayed can be highly inflated as they're based on % of single core. There could be many ways to remedy this. For example,

DECLARE @CoreCount INT = 1;
SELECT @CoreCount = COALESCE
(
   ( SELECT CAST(PropertyValue AS INT)
        FROM [dbo].[tbl_ServerProperties]
        WHERE PropertyName = 'cpu_count')
 , ( SELECT MAX(cpu_count)
  FROM [dbo].[tbl_dm_os_sys_info])
 , 1
);
Image Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions