Skip to content

For RDS SQL Server Is there a Limit On Concurrent Users in the "Express Edition"

0

Hi,

For RDS MSSqlServer Is there a Limit On Concurrent Users in the Express Edition.

Regards garevaul

asked 2 years ago987 views
3 Answers
3

I dont believe there is a limit on the connections. Mainly

  • the Size of the Database
  • Number of Cores
  • Memory
EXPERT
answered 2 years ago
AWS
EXPERT
reviewed 2 years ago
1

Hello,

The maximum number of simultaneous database connections varies by the DB engine type and the memory allocation for the DB instance class. SQL server allows the maximum of 32767 user connections.

References:

  1. https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-user-connections-server-configuration-option?view=sql-server-ver16

  2. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Limits.html#RDS_Limits.MaxConnections

EXPERT
answered 2 years ago
0

Hi

Thanx for your replies.

Sivaraman I think for SqlServer it is Unlimited (i.e. 0) (by Default)

According to the Article you gave a link to... (CHAP_Limits.html#RDS_Limits.MaxConnections) SQL Server Maximum number of concurrent connections 0–32767 0 (unlimited) Maximum number of concurrent connections

Regards garevaul

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.