CODEWITHSUNDEEP
azureazure-sql-databaseazure-sql-server
Win32Sector
Win32Sector

Reputation: 73

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?

Upvotes: 0

Views: 1327

Answers (1)

KarthikBhyresh-MT
KarthikBhyresh-MT

Reputation: 5034

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

Upvotes: 1

Related Questions