title: Need to know the number of concurrent connections allowed in Azure SQL Database
body: <p>I have following queries related to maximum number of simultaneous user connections allowed in Azure SQL Database.</p>
  
  <p>1.For Azure SQL DB ,depending on the tier i.e. basic,standard and premium what is the number of concurrent connections supported by the database ?</p>
  
  <p>2.How we can know this number ? Is there a query we can execute to know it or something in Azure portal UI ?</p>
  
  <p>3.Can this allowed number of connections increased/modified ? If yes, how ?</p>
  
  <p>As per Microsoft documentation ,there is one command "@@MAX_CONNECTIONS" which returns the maximum number of simultaneous user connections allowed on an instance of SQL Server (<a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/max-connections-transact-sql?view=sql-server-2017" rel="noreferrer">https://docs.microsoft.com/en-us/sql/t-sql/functions/max-connections-transact-sql?view=sql-server-2017</a>").But this is not applicable for Azure SQL Database.</p>