Does blocking has affect on High DTU utilization ?

  • ebooklub

    Hall of Fame

    Points: 3885

    Hi,

    Does blocking has affect on High DTU utilization ?  (some people advocate that Spike in DTU might be caused by high number of blocking processes , or long term blocking)

    DTU definition

    select convert(decimal(18, 0),AVG([avg_DTU_percent])) from

    (SELECT

    (SELECT Max(v)

    FROM (VALUES (avg_cpu_percent), (avg_data_io_percent), (avg_log_write_percent)) AS

    value(v)) AS [avg_DTU_percent]

    FROM sys.dm_db_resource_stats

    WHERE end_time>=DATEADD(MINUTE, -10, GETUTCDATE())) a

    where is blocking feet in?

    Thank you

    Alex

  • Site Owners

    SSC Guru

    Points: 80379

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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