Resource Utilization in Database elastic pool
I have few web jobs, which run parallelly. When they run parallelly, I get time out error with below stack trace.
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
at System.Data.SqlClient.SqlCommand. c. ExecuteDbDataReaderAsync b__122_0(Task1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke() at System.Threading.Tasks.Task. c. .cctor b__275_1(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
Assuming that it gets time out due to basic amount of resource allocation for elastic pool, I scaled up elastic pool from 50 to 100 eDTU and checked parallel run of web jobs. When it was running parallel jobs from 2021-06-10 11:00:00PM to 2021-06-10 11:59:59PM local time(UTC+5:30), elastic pool resource utilization and resource utilization from DB in green color as below. According to those reports it shows that while db in green color resource utilization is going 100%, at the same time total resource utilization from allocated 100eDTU is just 3%. My question is why it uses 3% resources only? There are 12 dbs in elastic pool. If it shared resources equally to each db it should be 100/12 = 8.33 at least. But according to idea behind the using of elastic pool, it should allocate more resources than that as it shares resources in between DBs.
Could someone please share any thoughts or tell reason behind that?
Thanks in advance
---Thushara---