Search code examples
azureazure-sql-databaseazure-sql-server

How can I change Max Pool Size for particular database in MSSQL elastic pool in Azure?


How can I change Max Pool Size for a particular database in MSSQL elastic pool in Azure?


Solution

  • You can change from Azure Portal > SQL-server > settings > configure

    See, Change elastic pool storage size

    enter image description here

    for database...

    enter image description here

    However, if you are looking for increasing beyond the Max size available, checkout: Resource limits for elastic pools using the vCore purchasing model and DTU purchasing model

    And....

    The following MS doc, Request quota increases for Azure SQL Database, describe the quota increase options for the SQL Database quota types:

    • Database transaction units (DTUs) per server
    • Servers per subscription
    • Region access for subscriptions or specific hardware