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
1
vote
0 answers

Deploying a split-merge service for Azure SQL Elastic (sharded) databases

I am trying to follow the tutorial for deploying a split-merge service (Azure Elastic Database... tools). The first complication is that the doc instructs me to create an "Azure Cloud Service." The closest thing to that seems to be "Cloud service…
dudeNumber4
  • 4,217
  • 7
  • 40
  • 57
1
vote
1 answer

How to query a replicated sharded database via Azure Elastic Scale?

I'm converting an existing solution to use multi-tenant shards instead of a single database. My primary database is replicated to a secondary Azure region (active geo-replication). We use this replicated database to fetch some data to reduce load…
Mateusz Turzyński
  • 11
  • 2
1
vote
2 answers

Performance Azure Elastic pool databases

We're running in to a similar issue as mentioned in Azure hits database cpu limits too easily. We are also using the Azure Elastic pool and are creating a new database for each customer. We use EF6-code-first to handle the SQL stuff. Using the web…
Paul Meems
  • 3,002
  • 4
  • 35
  • 66
1
vote
0 answers

Azure Elastic DB Migration: How to handle identity columns?

I have an existing sharded table with auto-increment identity column CustomerID. It appears with elastic scale you need an ID before you insert a record. How do I get the next ID from a sharded table?
James Grigley
  • 83
  • 1
  • 8
1
vote
1 answer

Elastic scale query with EF: Nullable object must have a value

On Azure, I have a setup of several sharded databases and an elastic query database with external tables mirroring the tables on the shards. The two main tables I use are: Channels: [Name] nvarchar NOT NULL, [Id] [uniqueidentifier] NOT…
SVC
  • 103
  • 1
  • 9
1
vote
2 answers

Could not find stored procedure '__ShardManagement.spBulkOperationShardMappingsLocal'

I am using azure Elastic database pattern with Entity Framework Code First. When I create a new Shard Database the follow exception is thrown when I try to create the PointShard map // Register the mapping of the tenant to the shard in the…
DownUnderDev
  • 11
  • 2
1
vote
1 answer

ShardManagement Binary ShardingKey Max Value

I am currently setting up my shardmap manager, shard map ... via the PowerShell script provided here. While the example uses int as ShardingKey type, I have a binary(16) ShardingKey, does anyone know how to determine and pass a high key of max…
Marcel
  • 189
  • 7
1
vote
2 answers

Elastic Scale Split/Merge tool fails unexpectedly

I'm using the Azure Elastic Scale Split Merge tool to move one shardlet to another shard. Everything seems to go as planned but in the end it fails without telling me why. This is the complete output of the log Status: Failed Details: [Error] The…
Arn Vanhoutte
  • 1,779
  • 4
  • 16
  • 28
1
vote
1 answer

How to create a sql database in Basic edition programmatically? in Windows Azure

The syntax for this is explained here: How to programatically create Sql Azure database of type Basic/Standard edition through Enity Framework code first However, my code is implemented like this: public static bool CreateDatabaseIfNotExists(string…
Luis Valencia
  • 32,619
  • 93
  • 286
  • 506
1
vote
1 answer

How to add a sql database to an elastic pool programmatically?

I have the following console application which creates a ShardManagerDB and creates one database for each company on the main database. I can see on azure the databases created on the server however they are not on the elastic pool. Question: 1. Is…
Luis Valencia
  • 32,619
  • 93
  • 286
  • 506
1
vote
1 answer

How to connect On-premise database servers to sql azure database server

I have 4 on-premise database server that has to be connected to Sql azure server as linked server.I will be querying these on-premise server from sql Azure database server.As far as I checked online I get the answer as it is not supported in Azure.…
Gugan
  • 13
  • 6
1
vote
1 answer

Azure Elastic Scale Sharding Key

I am moving my datamodel to Azure Elastic Scale. After some testing and some experiences I fall in love if it, it is simple and with that kind of approach the code remains clean and easy to maintain. I just have one big question, where is the…
Diogo Cunha
  • 1,194
  • 11
  • 23
1
vote
2 answers

Inserting mappings for a large amount of existing data

I am currently testing inserting a large amount of mappings for existing data into a shardmap using Elastic Scale. Turns out the whole process is time consuming. It's inserting around ~10 mappings/second. Is there anyway to speed up the insertion…
Marcel
  • 189
  • 7
1
vote
2 answers

How to immigrate from current federation system for Web Microsoft Azure databases to the new Elastic scale out in the Basic databases

we discover that the Microsoft Sql Azure Web databases are going to retired in the September 2015. our application (PHP application) is working on federation mechanism. how to convert our federation to the new elastic scale out? is there is a new…
Hussam Kurd
  • 8,066
  • 2
  • 43
  • 38
1
vote
1 answer

ElasticScale Preview - MultiShardConnection - DataSource must not be set in the connectionStringBuilder

Checking out the new ElasticScale of Microsoft and need to make a multiSharedConnection. Unfortunately this error arises : DataSource must not be set in the connectionStringBuilder my code is as simple as : var aa =…
Nikatlas
  • 184
  • 13
1 2
3
4