Lesson Learned #172: ApplicationIntent=Readonly in General Purpose database tier?

Published 05-21-2021 08:56 AM 794 Views

I saw in several situations that our customers are trying to use applicationIntent=Readonly parameter in their connectionstring, but, I would like to mention that this only applies when you have available and enabled ReadScale in Business Critical, HyperScale or Premium database tier. 

 

If you using ApplicationIntent=ReadOnly for database tiers, like basic, standard or general purpose the connection will be possible, but, instead of connecting to the read only replica will be directly to the primary one in readwrite model. 

 

Enjoy!

%3CLINGO-SUB%20id%3D%22lingo-sub-2375941%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%23172%3A%20ApplicationIntent%3DReadonly%20in%20General%20Purpose%20database%20tier%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2375941%22%20slang%3D%22en-US%22%3E%3CP%3EI%20saw%20in%20several%20situations%20that%20our%20customers%20are%20trying%20to%20use%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fread-scale-out%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EapplicationIntent%3DReadonly%3C%2FA%3E%20parameter%20in%20their%20connectionstring%2C%20but%2C%20I%20would%20like%20to%20mention%20that%20this%20only%20applies%20when%20you%20have%20available%20and%20enabled%20ReadScale%20in%20Business%20Critical%2C%20HyperScale%20or%20Premium%20database%20tier.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20using%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fread-scale-out%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EApplicationIntent%3DReadOnly%3C%2FA%3E%20for%20database%20tiers%2C%20like%20basic%2C%20standard%20or%20general%20purpose%20the%20connection%20will%20be%20possible%2C%20but%2C%20instead%20of%20connecting%20to%20the%20read%20only%20replica%20will%20be%20directly%20to%20the%20primary%20one%20in%20readwrite%20model.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEnjoy!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2375941%22%20slang%3D%22en-US%22%3E%3CP%3EI%20saw%20in%20several%20situations%20that%20our%20customers%20are%20trying%20to%20use%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fread-scale-out%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EapplicationIntent%3DReadonly%3C%2FA%3E%20parameter%20in%20their%20connectionstring%2C%20but%2C%20I%20would%20like%20to%20mention%20that%20this%20only%20applies%20when%20you%20have%20available%20and%20enabled%20ReadScale%20in%20Business%20Critical%2C%20HyperScale%20or%20Premium%20database%20tier.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎May 21 2021 08:56 AM
Updated by: