By default, SQL Server allows a maximum of 32767 concurrent connections which is the maximum number of users that can simultaneously log in to the SQL server instance. The default is 0, which means that the maximum (32,767) user connections are allowed. What happens if the total number of connections on any promotional events are more than 32,767? How SQL Server will be able to handle the situation?
Any guidance would be helpful.