Questions tagged [azure-elasticpool]
The azure-elasticpool tag has no usage guidance.
azure-elasticpool
92
questions
0
votes
1
answer
41
views
Does the performance of inserting data into Azure SQL database from Databricks affected by the sizing of the database?
I am now working on a use case which would need to ingest huge data (~10M of rows) from Azure Databricks materialized view to an Azure SQL database. The database is using the elastic standard (eDTU 50)...
- 15
0
votes
0
answers
27
views
Azure SQL backup policy
I have Azure SQL Elastic pool which manage my databases.
I'd like to have some automation which always set my custom backup retention policies, like weekly retention is 30days, for all newely created ...
- 25.4k
-1
votes
1
answer
56
views
Retirement of Azure SQL Database APIs 2014-04-01
I am referencing this MS document https://learn.microsoft.com/en-us/azure/templates/microsoft.sql/servers/recommendedelasticpools/databases?pivots=deployment-language-arm-template for "Microsoft....
- 1
0
votes
1
answer
233
views
Optimizing Azure SQL Elastic Pools with high memory but low CPU
I have a couple General Purpose SQL elastic pools that are configured at 8 vCores. The CPU of these pools peak no higher than 30% which inclines me to want to reconfigure the elastic pool (to maybe 4 ...
0
votes
1
answer
144
views
Moving data from Azure SQL to shards using elastic query
I am new to Azure Elastic Pool and here is what I am trying to achieve
An SQL database named "Source" contains several tables of which some are centered around Customers, which needs to be ...
- 33.4k
0
votes
1
answer
53
views
Elastic pool storage utilization percent not decreasing
We are using an elastic pool which has a number of databases.
As an exercise we have shrunk the databases however the storage utilisation of the elastic pool (% used space) which say is at 50 % has ...
- 67
0
votes
1
answer
360
views
How to move Azure Elastic Pool between different SQL Servers
I'm looking to move Azure Elastic Pool from one Azure SQL Server to another Azure SQL Server.
I'm not sure if its possible to do so, as I tried to look around internet for the same but couldn't find ...
- 384
-1
votes
1
answer
394
views
unexpected costs when using Elastic Pools
Can someone explain how sql databases are costed in azure when using an elastic pool. The Elastic Pools' service tear is "General Purpose (Most Budget friendly, serverless compute)", the ...
- 2,963
1
vote
1
answer
331
views
How to set the maintenance window for elastic pool in Bicep script?
I had no luck figuring out what to pass for "maintenanceConfigurationId" to set the maintenance window.
Here's the bicep:
resource sqlServer 'Microsoft.Sql/servers@2021-11-01' existing = {
...
- 1,543
0
votes
1
answer
1k
views
Azure terraform add database to elastic pool
I am trying to deploy to azure the following resource:
mssql server
mssql database
mssql elastic pool
as you can see from the following terraform code:
resource "azurerm_mssql_server" &...
- 1,399
0
votes
1
answer
190
views
Azure Data Factory - Scale elasticpool with web activity
I'm trying to scale my Azure elasticpool in datafactory with a web activity task passing the following api call:
{
"url": "https://management.azure.com/subscriptions/subID/...
- 303
0
votes
1
answer
142
views
I need to clone an Azure SQL Database, which will take it past the SQL Pool Max Data Size - will it automatically increase?
I have an Azure SQL Elastic Pool with 24 databases. The pool size in the portal is given as:
Used: 412 GB
Allocated: 540 GB
Max: 750 GB
One of the databases is around 300 GB and I need to take a ...
- 29
1
vote
1
answer
264
views
Delete database shard mapping and shard databases in SQL Server to clean up tenant resources
We have a database for each tenant as shown in the screenshot below.
I am trying to delete the tenant DB and clean up and reclaim the resources of a tenant I have anciently created. I tried the ...
- 563
3
votes
2
answers
5k
views
Azure Single Database vs Elastic Pool Databases
I have created an azure SQL single database "w3s_singledb" with no elastic pool and SQL server named "singledb2022dec". After logging into "singledb2022dec.database.windows....
1
vote
1
answer
1k
views
How do I create a database in an elastic pool using bicep?
I'm trying to set up a database into an elastic pool using Bicep. So far I've created a sql server and a related elastic pool successfully. When I try to then create a database that refers to these ...
- 5,321