Will Blocking cause timeout issue
There are two type of timeouts.
One is when the client application (API) aborts the batch after a certain amount of time. Called &quot;attention&quot; in a SQL server trace. Default in many APIs is 30 seconds.
The other is when the client requests that SQL server abort the query with error 1222 after a certain time. SET LOCK_TIMEOUT. Default is indefinitely.
Yes, if a blocking lasts longer than any of above timeouts values, then you will get a timeout.
Do the user consider waiting for a long time (blocking) and perhaps even getting a timeout as bad performance. Yes, absolutely.