tedious-connection-pool icon indicating copy to clipboard operation
tedious-connection-pool copied to clipboard

Add Exponential Backoff mechanism

Open gkorland opened this issue 9 years ago • 3 comments

The current retry mechanism is too aggressive for SQL Azure. Too many consecutive retries get "punished" by SQL Azure.

See:

  1. Retry service specific guidance
  2. Transient Fault Handling (Building Real-World Cloud Apps with Azure)

gkorland avatar Mar 10 '16 09:03 gkorland

@gkorland I want to make sure I've understood the issue correctly-- is it possible that some users would see wait times for whatever action they're taking in the UI reach minutes?

seanlindo avatar May 04 '16 02:05 seanlindo

@seanlindo no of course not but when a pool is retrying to fill the minimum connections it should use this retry gracefully.

gkorland avatar May 06 '16 10:05 gkorland

I'll try to find some time to look over this. But, I'd definitely accept a PR for this.

ben-page avatar May 06 '16 16:05 ben-page