Azure SQL Limit on external connections

Question

Post reply

Azure SQL Limit on external connections

Grinja

Hall of Fame

Points: 3590
More actions
February 5, 2024 at 6:23 pm

#4373728

Hello All,
I have a use case to setup a Azure SQL DB for analytics and report developers.
Planning for 20 people that will be connecting via SSMS/Azure Data studio/ PBI , excel etc.
Reading the documentation there appears to be a very strong limit on external connections (which I assume the above are?)
Is increasing to an S3/S4 tier the only way to get around this , any insights would be helpful.
https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-dtu-single-databases?view=azuresql
Cheers.
G

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80320 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Steve Jones - SSC Editor SSC Guru Points: 734459 More actions · Answer 2

AFAIK, yes. You could use some sort of middle tier app server with connection pooling, which might get you more, but the low levels are low as they are stacked on a server, so they really limit the client connections.

Steve Jones - SSC Editor SSC Guru Points: 734459 More actions · Answer 3

AFAIK, yes. You could use some sort of middle tier app server with connection pooling, which might get you more, but the low levels are low as they are stacked on a server, so they really limit the client connections.

Grinja Hall of Fame Points: 3590 More actions · Answer 4

Thanks for the feedback Steve.

I will need to look at some options then for pooling the connections.