New answers tagged max-connections
Also if you want to restrict number of concurrent connections then Resource Governor comes in handy. Can even tailor it to specific logins only.
Seems like we can do it : To configure the user connections option In Object Explorer, right-click a server and click Properties. Click the Connections node. Under Connections, in the Max number of concurrent connections box, type or select a value from 0 through 32767 to set the maximum number of users that are allowed to connect ...
I don't know such setting on the server level, but you can write the server-level trigger on connect action which will check the connections' count to the needed DB (bazed on DMVs) an, in case of over limit, will restrict the connection.
Max_connections is The total number of concurrent connections allowed by the MySQL server. If you are getting Too many connections' error, it means that you have reached this limit. Also, You should observe threads_running variable value for a period of time to determine exact value for 'max_connections'. You can consider max_connection value as ...
Top 50 recent answers are included