average duration increasing inline with exec counts

• simon_s

  Ten Centuries

  Points: 1360

  More actions

  May 30, 2025 at 11:12 am

  #4599871

  As the title says , I've got a handful of stored procs where the avg duration rises and falls pretty much mirroring the exec count. I've looked to see if there's any blocking chains they're involved in and cant seen anything that would account for the behaviour. Whilst Id obviously expect total duration to do this I cant explain why the avg is following suit . Any ideas ?

  many thanks Simon

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 31, 2025 at 12:10 pm

  #4600389

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

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