Stack Overflow
Stack Overflow

Questions tagged [azure-elasticpool]

87 questions
39
votes
5 answers

Azure: How to move databases into Elastic Pool

We have a few databases in Pricing Tier: Basic, S0... like below picture: These databases were created before a new Elastic Pool is created. Now we want to move these databases into Elastic Pool for costing saving. But it seems I don't know how to…
cuongle
  • 74,024
  • 28
  • 151
  • 206
14
votes
1 answer

SocketTimeoutException while retrieving or inserting data into Elastic Search by using Rest High Level Client

I'm facing SocketTimeoutException while retrieving/inserting data from/to elastic. This is happening when there are around 10-30 request/second. These requests are combination of get/put. Here is my elastic configuration: 3 master nodes each of 4GB…
AshwinK
  • 1,039
  • 1
  • 12
  • 31
6
votes
2 answers

How to programmatically create an Azure SQL Database in an Elastic Pool?

I want to write code in C# which would programmatically create and add an Azure SQL database into an existing elastic pool. I have looked into the Elastic Database Client Library, but it does not handle creation of databases, only registering…
anonuser1
  • 347
  • 1
  • 7
  • 17
6
votes
2 answers

Azure SQL Server Elastic Pool - automatically add database to pool

Currently we have an Azure SQL Server and each time we create new web app, we use EF Core Code First to generate the database. However after the database is created we manually go to Azure portal and add the newly created database to the Elastic…
user2818430
  • 5,853
  • 21
  • 82
  • 148
5
votes
1 answer

Azure SQL multiple Elastic Pools (Multi-Tenant SaaS)

Let's suppose I want to create a multi tenancy SaaS app using ASP.NET Core and I want to use Azure SQL elastic pool similar to this example: Microsoft Docs The maximum number of databases per pool is 500: Azure Pricing Additional information: I…
Chris
  • 6,105
  • 6
  • 38
  • 55
5
votes
4 answers

Azure SQL Server Error : The elastic pool has reached its storage limit. The storage usage for the elastic pool cannot exceed (204800)

When I am trying to update or insert multiple rows from the application or directly sql server database, I am getting the error as below. Msg 1132, Level 16, State 1, Line 1 The elastic pool has reached its storage limit. The storage usage for…
Anoop H.N
  • 1,244
  • 1
  • 15
  • 31
4
votes
2 answers

Is there downtime while Scaling Azure SQL Elastic Pool Storage?

I have an Azure SQL Elastic Pool with 800 eDTUs and 400GB of Storage. In past, I used to have 400 eDTUs, and when I scale to 800 eDTUs I had a small downtime in the website (~15-30 seconds), so before making any changes to the storage, I'd like to…
Vinicius Deschamps
  • 385
  • 3
  • 15
4
votes
2 answers

Is it possible to make azure elastic pool scale automatically?

As titled, I am trying to automatically scale my Azure databases. I have found a powershell workflow script for a single database, which works perfectly. I was wondering if it is possible to automatically scale my elastic pool. I have tried to…
Lancer Xue
  • 118
  • 2
  • 9
4
votes
1 answer

SQL Azure elastic pool max DTU per database

We are using SQL Azure and we have our databases in Elastic pool. It has following parameters: Number of DTUs allowed for the entire pool is 400. Maximum allowed DTUs per database is 100. Number of databases in pool is 50 Simply said 4 of 50…
michal.jakubeczy
  • 8,221
  • 1
  • 59
  • 63
2
votes
3 answers

Terraform Azure - Move an existing Azure SQL Database into an Elastic Pool

I have an existing Azure SQL Server and 1 database that wasn't created into an Elastic Pool initially. Terraform has deployed this and kept the state. # Define SQL Server 1 resource "azurerm_mssql_server" "go-1" { name =…
nmca70
  • 183
  • 3
  • 16
2
votes
2 answers

How create a database in azure elastic pool with entity framework core?

I would like to create a database with entity Framework core that would be automatically added to my azure elactic pool. I do that with a DatabaseFacadeExtension that execute SQL command after the db creation like suggested here: Azure SQL Server…
Kassoul
  • 21
  • 2
2
votes
1 answer

Azure SQL - How to add AD users to SQL Pool Databases

Problem: I am trying to add active directory users & groups (synced from on-prem to Azure AD) to SQL databases that exist in a SQL elastic pool on Azure in the same tenant. I do not want to use SQL Server Authentication (integrated). It seems that I…
Stinkys
  • 79
  • 1
  • 5
2
votes
1 answer

Scaling an Azure Elastic Pool with .NET Fluent API

I'm using the Azure Fluent API, Azure Management Libraries for .NET, to scale the DTU's within an Azure Elastic Pool and would like to know if it's possible to trigger an update without having to wait for the processing to complete. Currently the…
jdtaylor
  • 334
  • 2
  • 5
  • 20
2
votes
2 answers

Azure SQL database and pool usage. When to use database pool

Hello I have 14 Databases for Azure SQL with DTU SO, S1 and S4 (prod) So I am paying for some unused or not frequently used databases. 10 databases for Dev and test. 2 for production. So I saw one post for Azure elastic pool. It was mentioned with…
Kunal
  • 77
  • 12
2
votes
1 answer

If I remove databases from Azure elastic pool will I need to update SQL queries in the codebase?

I am currently using Microsoft Azures elastic pool to allocate resources to my databases as needed, however for my purposes at the moment the cost is too high for the amount of traffic the databases are handling. My question is if I removed the…
Alan
  • 302
  • 5
  • 22
1
2 3 4 5 6