Stack Overflow
Stack Overflow

Questions tagged [azure-elastic-scale]

Azure SQL Database Elastic Scale enables the data-tier of an application to scale out and in via industry-standard sharding practices.

Azure SQL Database Elastic Scale enables the data-tier of an application to scale out and in via industry-standard sharding practices, while significantly streamlining the development and management of your sharded cloud applications. Elastic Scale delivers both developer and management functionality which are provided through a set of .Net libraries and through Azure service templates that you can host in your own Azure subscription to manage your highly scalable applications. Azure DB Elastic Scale implements the infrastructure aspects of sharding and thus allows you to focus on the business logic of your application instead.

Source: "Get Started with Azure SQL Database Elastic Scale Preview"

60 questions
0
votes
3 answers

Database design issue for Multi-tenant application

We have an application that does lot of data heavy work on the server for a multi-tenant workspace. Here are the things that it do : It loads data from files from different file format. Execute idempotence rules based on the logic defined. Execute…
abhishek
  • 2,975
  • 23
  • 38
0
votes
1 answer

Query execution slow when scaling DTUs in Azure SQL Database

Am doing some POC with real-time scenarios for SaaS product to handle high volume of message, this will reach peak within few seconds(send/process) and listener side processing message then storing that computed data into Azure SQL Database(Separate…
Kalaivanan2k4
  • 37
  • 5
0
votes
1 answer

Elastic range query not return results when GTE value is over 100

I am working with Elastic Search on Azure. In my elastic index I have the following document: { "minimumwidth": 30, "minimumheight": 60, "maximumwidth": 62, …
Michael Edwards
  • 6,308
  • 6
  • 44
  • 75
0
votes
1 answer

Migration on .netcore app which uses always encrypted and elastic scale

Our platform uses elastic scale and always encrypted. Now we migrated to .netcore As I understood, always encrypted on .netcore supported by Microsoft.Data.SqlClient which contains copies of classes that support always encrypted. But Elastic scale…
Vlad Polishchuk
  • 11
  • 2
0
votes
2 answers

Update elastic pool EDTUs through ARM template

Initially we had deployed database elastic pool in Azure though ARM template. The pool is in Standard edition and had 50 EDTUs in total. This is happening when deploying the app from VSTS through release management. At some point the databases grew…
xabikos
  • 195
  • 11
0
votes
1 answer

Database per tenant hosting advice (high scalability)

We are currently producing a web application with database per tenant logic. Our current database setup is all hosted on a single VM with a one instance free SQL express edition. All database are dynamically created server-side and added to the same…
Pilouk
  • 1,267
  • 1
  • 18
  • 36
0
votes
0 answers

ListShardMap. UpdateMapping throws an exception LockOwnerId Cannot be Null

I tried different ways and googled a lot for the error but no luck so far. I am trying to make a function which can update an existing shard mapping but I get the following…
Inayat
  • 23
  • 9
0
votes
1 answer

How to add new data sources without changing elastic query?

We have a scenario in which we wish to use Azure Elastic Query so as to allow us to run aggregate queries on multiple databases geographically distributed, and which might be added to with time. However, we can't yet find useful docs or advise on…
JWL
  • 13,591
  • 7
  • 57
  • 63
0
votes
1 answer

Update a row of a table in a elastic pool Db using Elastic Query

I have a SQL Server in which I have created 'n' numbers of elastic pool DB with identical schema and tables. I want to update a column Column1 in a table table1 in a elastic pool database as ElasticDB1 using Elastic query. Is it possible? If yes,…
Skull
  • 1,204
  • 16
  • 28
0
votes
2 answers

Entity Framework with elastic pool. How to manage my SaaS client database?

I am currently looking to build an SaaS in ASP.Net hosted on Azure Cloud. I am looking for advice on how to best build my database and the Entity Framework that goes with it. Once a customer registers on the web app, the app needs to create a…
Thierry Prost
  • 1,005
  • 11
  • 22
0
votes
1 answer

Azure Elastic Scale: MarkMappingOffline does not prevent shards from being searched

Just looking for some clearer understanding of what happens under the hood when RangeShardMappings are marked offline. I understand mappings need to be set offline to update and delete shards and mappings. I would like to keep mappings but prevent…
redstubble
  • 121
  • 2
  • 12
0
votes
2 answers

'New-ShardMapManager' is not recognized as the name of a cmdlet trying to access through powershell

Steps I used: Login-AzureRmAccount -- I ran this cmdlet in Powershell in admin mode once logged I ran this below query New-ShardMapManager -UserName 'user_name' -Password 'enterd password' -SqlServerName 'server_name.database.windows.net'…
vishvas
  • 1
  • 1
0
votes
2 answers

SQL Server move data between databases

We have a requirement where we will have to move data between different database instance on regular basis. (For e.g. some customers willing to pay more for the better performance). So this is not going to be one off. The database tables has…
activebiz
  • 6,000
  • 9
  • 41
  • 64
0
votes
1 answer

How to move shardlets to a different shard using Elastic Scale in code

Reading the documentation of Elastic Scale it appears as usually when moving shardlets one would use the Split/Merve/Move service. My question now is, how can I trigger a move of a shardlet in code? Could I trigger the service "api" as demonstrated…
Marcel
  • 189
  • 7
-3
votes
1 answer

What is the best way to implement multi tenancy in Azure Database

We are planning to implement a multi tenant application in Azure cloud. I am looking for a best way to implement this in DB level. The DB schema is huge, we have 100s of tables spread across multiple modules. And the data size varies for each…
sreehari
  • 9
1 2 3
4