Maximum concurrent connection Azure DB handle

Question

Maximum concurrent connections Azure DB handle?

General Purpose (Both Provisioned/Serverless)?

Hyperscale(Both Provisioned/Serverless)?

Answer 1

The following statement shows you the maximum number of connections for the current tier.

SELECT @@MAX_CONNECTIONS AS 'Max Connections';

The limits for Azure SQL Database DTU-model can be found here. The Limits for vCore Model can be found here. You can find Serverless limit for session and connections here.