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
77
votes
2 answers

Can't query between databases in SQL Azure

I have a SQL Azure Database Server and I need to query between the Databases but can't figure out how to accomplish this. Here is the structure of my databases: Server.X Database.A Database.B Database.C In Database.A I have a Stored Procedure…
JoeGeeky
  • 3,746
  • 6
  • 36
  • 53
41
votes
4 answers

Autoscaling Azure SQL Database

We have an application that uses Azure SQL for the database backend. Under normal load/conditions this database can successfully run on a Premium 1 plan. However, during the early morning hours we have jobs that run that increase database load.…
kspearrin
  • 10,238
  • 9
  • 53
  • 82
8
votes
3 answers

Enable-Migrations "Object reference not set to an instance of an object"

I just created a new service fabric service that will periodically attempt to save some models to SQL Azure using Entity Framework and the Elastic Client Database library. I'm trying to model it as closely as I can to the SQL Azure Elastic Scale…
Steve W.
  • 413
  • 1
  • 5
  • 12
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
6
votes
1 answer

Executing an Elastic Scale multi shard query on the database context

I'm busy implementing the new Elastic Scale technnology in a project I'm working on at the moment. This technology appears to solve some complex issues we were having while designing the new application foundation. So far, the examples look great…
Jan_V
  • 4,244
  • 1
  • 40
  • 64
5
votes
1 answer

Cannot delete shard mapping using Azure SQL Elastic Scale

We have an entity in our system called an "identity program." That is also our sharding boundary, every identity program is stored in its own shard, so the identifier of the shard is the identifier of the identity program. We are in the process of…
Craig W.
  • 17,838
  • 6
  • 49
  • 82
5
votes
1 answer

What is the difference between ReferenceTableInfo to ShardedTableInfo in Azure Elastic DB?

I downloaded the sample code -> "ElasticScaleStarterKit" (in visual studio -> file -> new -> project -> online -> Elastic DB Tools for Azure SQL - getting Started). the schema defined as follows: schemaInfo.Add(new…
ZoharYosef
  • 247
  • 1
  • 2
  • 11
4
votes
3 answers

Timeout expired. The timeout period elapsed prior to completion of the operation on Azure sql

I need to create one sql database on windows azure on the global.asax application start event, however I got this error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. This failure…
Luis Valencia
  • 32,619
  • 93
  • 286
  • 506
3
votes
1 answer

Azure Elastic Database Merge GUI Key Shards

In Azure we have four Shards and i want to remove two of them as we do not need them anymore. The Data should be merged into the other two Shards. I use a Listmap with GUIDs as Key to identifiy the Shard (in our application this is the UserId). In…
metabolic
  • 669
  • 1
  • 7
  • 24
3
votes
1 answer

Adding new shard - Azure Elastics Scale

I was facing trouble creating a new shard for our system. I have an already sharded database, with two shards. 0-280000 280000-inf I am using the this application provided by Microsoft. Using the above app I select add shard and when I try to add a…
imrn
  • 297
  • 2
  • 12
3
votes
2 answers

Elastic database Split-Merge tool issue while splitting an existing shard

We recently have moved to Azure Elastic Scale DB. So when we need to create another shard, our DBA splits an existing shard manually. So I have been given the task to automate that process so we can easily split an existing shard or merge multiple…
Aamir
  • 1,747
  • 5
  • 26
  • 50
3
votes
1 answer

SQL Azure Elastic Scale - reference table

I am not sure if I understand the idea of reference tables correctly. In my mind it is a table that contains the same data in every shard. Am I wrong? I am asking because I have no idea how should I insert data to the reference table to make the…
user2229474
3
votes
3 answers

MultiShardQuery on SQL Azure Elastic Scale with Entity Framework

I am new in Azure and I am trying to implement multishard query using Elastic Scale and Entity Framework. Unfortunately I am not able to find any example solutions or good practises to achieve that target. Can anyone help me in this issue? I would…
user2229474
3
votes
0 answers

How to clean up elastic scale databases

While testing Elastic Scale I wanted to start over a couple of times without deleting the complete databases. Since this might save you some time I though I would share the following SQL to cleanup databases used for Elastic Scale Shards and the…
Marcel
  • 189
  • 7
3
votes
1 answer

Migrate data between shards

For the project I'm working on, we need the customer data in a database nearby the customer. For this reason we have adopted the new Elastic Scale solution from Microsoft. This takes away the complexity of sharding and still gives you the power to…
Jan_V
  • 4,244
  • 1
  • 40
  • 64
1
2 3 4