Stack Overflow
Stack Overflow

Questions tagged [azure-elasticpool]

87 questions
0
votes
1 answer

Is it possible to change Azure Elastic Pool server version

I created a new instance of SQL elastic pool server, the displayed version of sql server is 12.0.2000.8. Is it possible to upgrade it to 13.x ?
Sam
  • 2,673
  • 2
  • 15
  • 20
0
votes
1 answer

List all databases by elastic pool using T-Sql in Azure Sql

There is a need that I need to create a query (T-Sql) where I will list the databases (name) given the elastic pool name. However, I couldn't find a sys.stats*** table or view that will give me this information , the simplest query I want to run is…
Dan Hunex
  • 5,172
  • 2
  • 27
  • 38
0
votes
1 answer

where to check the resource usage for azure SQL server

I want to check the DTU usage or vcore usage pattern by azure SQL server. I need to get the usage data to convert the single database to an elastic pool. Where on azure portal can I check the units consumed by the database?
user961
  • 453
  • 6
  • 20
0
votes
1 answer

Do Azure SQL Databases in a Elastic Pool use the pool's storage?

Saw the below specs about Azure SQL Database in Elastic Pool, could someone please explain why a pool with 500 GB storage limitation could hold 100 databases and each database could go up to 1 TB storage if the databases need to use pool's storage…
J.W
  • 671
  • 7
  • 23
0
votes
1 answer

Azure MSSQL Server slow ingestion

I am trying to ingest 9,000,000 rows in an elastic pool database with 6 Vcore. Data ingestion using python (pyodbc). Since data is large, I am ingesting the data in chunks. I am getting weird behaviour after the 9th chunk of the ingestion. Process…
Kallol Mistry
  • 1
0
votes
1 answer

Running flyway to migrate db to Azure SQL db: Unable to obtain connection from database

I have a flyway script that I run to migrate my db to Azure SQL db. Looks something like this: flyway.url=jdbc:sqlserver://myazuresqlserver.database.windows.net/myazuresqldatabase;ssl=request;integratedSecurity=false;…
Mary
  • 131
  • 2
  • 10
0
votes
1 answer

Using new Azure dotnet SDK for ElasticPool size

I'm trying to use the new Azure dotnet SDK for managing the size of our pool. Using the following code I can return some of the pool details: ResourceIdentifier id = new ResourceIdentifier(idStr); ArmClient client = new ArmClient(new…
mattb
  • 384
  • 1
  • 4
  • 24
0
votes
1 answer

What is the maximum number of Sql Elastic Pool you can have in Gen 5?

I am trying to figure some things in azure sql but I couldn't find any helpful documentations? I know the maximum number of database in Gen5 tier per server instance is 5000. I also know the sql elastic pool max data storage size is 5TB. Based on…
Dan Hunex
  • 5,172
  • 2
  • 27
  • 38
0
votes
1 answer

Latency in scaling VCore( say from 2 to 4) of Elastic Pool vs Create new Pool with VCore (4) and moving the databases

We have sort of a load balancer implemented for sql elastic pools. Basically it merges two pools, or splits two pools or scales up storage based on some reference settings (compute, storage etc) and the stats we get from the sql server. In some…
Dan Hunex
  • 5,172
  • 2
  • 27
  • 38
0
votes
2 answers

How to scale Azure Elastic Pools

I'd like to automatically scale our elastic pools so that between 8am-6pm we give them lots of resource, and between 6pm-8am we give them very little resource. I can use powershell to scale the elastic pool up and down... Set-AzSqlElasticPool…
RyanBreakspear
  • 29
  • 7
0
votes
1 answer

elastic query for update and insert

Source: SQL Server 2008 R2 Destination: Azure SQL Database in an elastic pool I am migrating multiple databases from source to destination using offline DMS. While migrating these databases some stored procedures are giving errors because of…
shubhi jain
  • 29
  • 3
0
votes
2 answers

Adding and removing Azure database to failover group in elastic pool with TSQL or Azure API C#

Creating database and adding to failover group I have an Azure elastic pool and I have created a failover group with another elastic pool (with the same name) on a different Azure region, during the creation of the failover group I selected the…
WebFletch
  • 172
  • 1
  • 16
0
votes
0 answers

SQL "DELETE FROM ... " doesn't work because elastic pool is full

I'm trying to remove some rows from my table, because the elastic pool (Azure) is full. However, apparently deleting doesn't work when the pool is full. I'm trying to run this statement in SQL Server Management Studio (SSMS): DELETE FROM [xx].[xxx]…
Jordy W
  • 1
  • 1
0
votes
2 answers

Azure ElasticPool "BadRequest" during creation deployment when using ARM template

I have a task where I need to use ARM template to "setup SQL server with elastic pool and 2 databases (imported from bacpac files) use Microsoft Adventureworks samples." Most of the template I made using "101-sql-elastic-pool-create" template that…
KarlisAG
  • 21
  • 4
0
votes
0 answers

Entity Framework Core - Setting an Azure SQL instance to be provisioned within an Elastic Pool (Not T-SQL)

Context We have a series of development databases - Azure SQL - that we use for testing. These databases are frequently dropped and created again. We want to start using an Elastic Pool for a better managing of costs. We're using Entity Framework…
Adelmo Magalhães
  • 41
  • 3
1 2 3
4
5 6