Lesson Learned #208: Hands-On-Labs:10928-Resource ID:2.The session limit for the database is reached

Published Jun 26 2022 03:30 AM 2,103 Views

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!

Version history
Last update:
‎Jun 28 2022 03:19 PM
Updated by: