Google > SQL >

SQL Server User Connections Flag

MEDIUM
Source
CloudSploit
ID
sql-server-user-connections-flag

SQL Server User Connections Flag

Ensure that user connections database flag for Cloud SQL Server Instances is set to desired value.

The user connection flag represents the maximum number of simultaneous connections that are allowed on an SQL Server instance. By default, it is set to 0 which means maximum connections are allowed. If the user connections flag is set to a limiting value, SQL Server will not allow any connections above the limit. If the connections are at the limit and will drop any new requests causing potential data loss or outages.

Ensure that all SQL Server database instances have user connections flag set to your organization recommended value.