This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.
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 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
- When Resource ID = 1, this indicates a worker limit has been reached. Learn more in Error 10928: Resource ID : 1. The request limit for the database is %d and has been reached.
- When Resource ID = 2, this indicates the session limit has been reached.
In this video we are going to give some insights about it:
Why this issue happens?
- 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 the connections.
- Scale up your database.
Enjoy!