Troubleshooting - Timeout from database without a specific procedure
0
votes
1
answer
55
views
I've got a performance degradation without a specific stored procedure being timeout.
there are some errors here it is listed from most to least:
1. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (97% of the errors)
2. Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
3. A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 35 - An internal exception was caught)
4. The lock supplied is invalid. Either the lock expired, or the message has already been removed from the queue. For more information please see https://aka.ms/ServiceBusExceptions . Reference:0a6d4e92-5df9-461e-9f02-80a863f6f975, . For troubleshooting information, see https://aka.ms/azsdk/net/servicebus/exceptions/troubleshoot .
My enviorment is : SQL azure PAAS (P11)
There are no high DTU for this database (about 40%) at max.
and there is few timeout for 1 stored procedure (from the query store)
Most of the time when i have a timeout issue
i have a specific problematic stored procedure and this is not the case.
is it a application error (the max pool issue)
i've read somewhere that in the connection pool you can use the MAX thread to keep a connection idle.
how can i troubleshoot this?
Asked by dexon
(65 rep)
Aug 1, 2024, 05:16 AM
Last activity: Aug 1, 2024, 09:53 PM
Last activity: Aug 1, 2024, 09:53 PM