This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 63%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBW%3C/text%3E%3C/svg%3E)
I've got an Azure SQL database running, <100 records. I use the database for development, but that came to a halt today, I've apparently hit the session limit:
ConnectionError: Resource ID : 2. The session limit for the database is 300 and has been reached. See 'https://docs.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance.
There are 6 total devs on the team, so we really shouldn't be hitting 300 sessions. Is there something that's preventing the sessions from closing? Is there some way to force close them? I can't even get into the query editor on the website.
@Ben White Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer, if you have any further query do let us know.
Probably the Developers is not the issue but the applications your are developing and testing. In this scenario or you need to control the number of connections in the application side, or if you really need more concurrent session you need to scale up to higher tier.
The database tier is Basic (DTU-Model) please consider using Serverless for Dev/Test. Serverless can get auto-paused when not in use.
(I believe) I was able to resolve this on the javascript API side, by closing the connection when the requestCompleted event is thrown.
As we mentioned, it is usually something that has to be controlled on the application side.