Post reply

SQLProcessUtilization counter above 100%

  • June 18, 2015 at 10:27 am

    #301769

    Does anyone know why/when this counter exceeds 100%?

    It is obtained from sys.dm_os_ring_buffers DMV. normally it matches external CPU Utilization from resource manager but I have a workload where it goes to 190% (roughly double of actual 80% host utilization)

    I believe this is occurring when thread pooling kicks in, i.e. workload exceeded max_worker_thread limit.

    Physical host with NO Hyper-threading or Virtualization. Plain cores.

    Thanks!

  • June 18, 2015 at 10:32 am

    #1806461

    Quick question, does the see er have two cores / CPUs?

    😎

  • June 18, 2015 at 11:09 am

    #1806475

    Two sockets @ 10 core each = 20.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply