We used to have cases where our customer faced the following error message: "10928-Resource ID : 2. The session limit for the database is x and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance." in this video below we are going to give some insights about it.
The Resource ID x indicates the resource that has reached the limit. You could find more information here
In this video we will cover scenarios causing error - 10928-Resource ID : 2. The session limit for the database is x and has been reached and mitigation steps.
Why this issue happens?
- Occurs when you reach the maximum number of connections available for your database (hard limit).
How to find the number of session opened?
- SQL SERVER Management Studio
How to fix the issue?
- Close all connections.
- Scale up your database.
Enjoy!
