Questions tagged [azure-elasticpool]
87 questions
0
votes
1 answer
Restore Database Fails - Azure SQL Database In ElasticPool
Attempts to restore a .bak file stored in Blob Storage to an Azure SQL Managed Instance fails.
This database exists in an Elastic Pool. When creating the pool and database, we thought we were creating a Azure SQL Managed Instance. There are posts…
ghoh
- 65
- 1
- 12
0
votes
1 answer
How to copy database within elastic pool using PowerShell
Could you please advise the PowerShell code which copies one database into another within the same elastic pool?
I was trying to use
New-AzureRmSqlDatabaseCopy, but the execution failed because New-AzureRmSqlDatabaseCopy is not intended to work…
MarinaAX
- 41
- 8
0
votes
1 answer
Is elastic pool only for databases with same schema?
I read in a blog that the elastic pool benefits were only for databases that have the same schema, is that true? Or do we get all the elastic pool benefits even with databases that doesn't have the same schema?
foluis
- 988
- 2
- 10
- 23
0
votes
1 answer
Can't Delete shard from Azure Elastic Pool
Have troubles with deleting shard from shard map in azure Elastic pool
var isMapKeyExists = shardMap.TryGetMappingForKey(tenantId, out PointMapping pointMapping);
if(pointMapping.Status == MappingStatus.Online)
{
…
J.Doe
- 53
- 1
- 5
0
votes
1 answer
What is the difference between standard elastic pool DTU and premium elastic pool DTU in Azure?
What performance differences are there between standard and premium DTUs in Azure elastic pools?
thomius
- 784
- 2
- 9
- 21
0
votes
1 answer
Could azure data warehouse be inside an Azure SQL Elastic Pool?
I am just wondering if there is any possibility to add an Azure data warehouse database into an Azure elastic pool. From my knowledge, an Azure DWH database can have 500 MB in size but an elastic pool has a maximum quota of 250 MB. Is it the reason…
George Lica
- 1,798
- 1
- 12
- 23
0
votes
1 answer
Azure Elastic Database Pool
I am in the process of designing a SaaS system that will be running in Azure and utilizing SQL Server. The application will leverage an Azure Elastic Database Pool to support scaling out via Sharding. The plan is to run a Shared-Sharded model and…
connectedsoftware
- 6,987
- 3
- 28
- 43
-1
votes
1 answer
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 hardware is set to Standard-series (Gen5). We have set the…
Richard Banks
- 2,946
- 5
- 34
- 71
-1
votes
1 answer
Azure Elastic Pool eDTU and Storage per DB / Pool?
This is regarding azure SQL database pricing, in elastic pool, standard 50 eDTU performance level, they have mentioned that there are 50 eDTU and 50 GB per pool and 100 DBs, i want to confirm whether the mentioned resources is per pool or per…
Fazlyn
- 35
- 5
-1
votes
1 answer
Cross Database query is not working in Azure SQL elastic pool
I am having two different database in azure sql server i have a sp in which we are executing select statement from another database inside same server both database are in same elastic pool where they will share the resources but we are getting this…
Arun Kumar
- 1
- 2
-2
votes
1 answer
Is Azure SQL Elastic Pool the Right Choice for Having Separate SQl DB in DEV and PROD Environment
When hosting a Web app using a SQL DB in Azure, we need a separate SQL DB in DEV & PROD environments. Will using Elastic Pool be the better choice than Single database with 1 instance?
It looks like the cost for 2 databases using Elastic Pool (1…
bedrock
- 263
- 1
- 2
- 15
-2
votes
1 answer
Splitting cost of Elastic Pool per client
We have a situation where we are hosting a database per client in an Elastic Pool. We are trying to determine how to fairly charge the customers based on how much they use the databases.
Whatever the metric it needs to be something we can pull per…
SteveyCNash
- 5
- 3