Does blocking has affect on High DTU utilization ?

• ebooklub

  Hall of Fame

  Points: 3905

  More actions

  November 19, 2019 at 5:01 pm

  #3698911

  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: 80320

  More actions

  November 20, 2019 at 5:10 pm

  #3699279

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

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