Post reply

Azure SQL Limit on external connections

  • 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

     

  • February 6, 2024 at 7:10 pm

    #4374359

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

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

  • February 6, 2024 at 7:37 pm

    #4374369

    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.

     

  • February 6, 2024 at 7:39 pm

    #4374371

    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.

     

  • February 15, 2024 at 3:34 pm

    #4379240

    Thanks for the feedback Steve.

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

     

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

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