Azure SQL Elastic Performance Scale
sql,sql-azure,azure-scheduler,azure-elastic-scale
I wrote the following Azure Automation workflow for your exact scenario [Azure SQL Database: Vertically Scale]. In full disclosure, there is an open issue running the script against SQL Database v12 right now. I am actively working on it and will post on the script center page when resolved. (2/28)...
How to connect On-premise database servers to sql azure database server
Azure SQL DB is previewing Elastic Database Query feature at this point in time that will help you query from Azure SQL DB to other DBs. You can get detailed information about the feature here. Thanks Silvia Doomra...
ElasticScale Preview - MultiShardConnection - DataSource must not be set in the connectionStringBuilder
I found the solution. Finally it seems that on the connection string the Server parameter should not be passed. "Server=tcp:MYSERVER.database.windows.net,1433; < --- DELETED This User [email protected];Password=MYPASS; Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" Probapbly the Data Source shown in exception is the same as Server EDIT As correctly commented by Jared Moore "@MYSERVER" in the...
Split/merge shardlets which have 'nested' foreign key references
c#,sql,azure,sql-azure,azure-elastic-scale
The Split/Merge service will track FK dependencies and move tables in the right order. It is important that even the OrdersLines table contains the sharding key (customer key), and then it also needs to contain an order-key as well to handle the FK. But this key doesn't need to be...
Migrate data between shards
c#,azure,sql-azure,azure-elastic-scale
The version of Split/Merge in the current preview for Azure SQL DB Elastic Scale has the known limitation that it only works with range shard maps. I am assuming that you are currently using a list shard map for your guids. While we are currently working on making support for...
SQL Azure Elastic Scale - reference table
azure,sql-azure,azure-elastic-scale
Yes, the idea of a Reference Table is that the same data is contained on every shard. If you have small numbers of shards and data changes are rare, you can open multiple connections in your application and apply the changes to multiple DBs simultaneously. Or you can construct a...
How to move shardlets to a different shard using Elastic Scale in code
Thanks for your question. Right now, the approach in the PowerShell script is the best option you have. However, we are not particularly happy with that and would like to replace it with proper APIs. I'll be in touch with you to find out more about how your automation environment...
Inserting mappings for a large amount of existing data
We know from our own testing that inserting mappings is time consuming. Here are a couple of options I'd suggest you try: You can run multiple parallel threads inserting the mappings. You can increase the service level objective for the shard map database for the time where you do the...
ShardMapManager.TryGetRangeShardMap wont retrieve the RangeShardMap
c#,azure,sql-azure,azure-elastic-scale
This was a silly mistake from my side. I was about to close this question but thought to post my mistake here as it might be helpful to someone else. The code to call this function was like this: RangeShardMap<int> shardMap = ShardManagementUtils.CreateOrGetRangeShardMap<int>(shardMapManager, Configuration.ShardMapName); Notice the int which tells the...
Elastic database Split-Merge tool issue while splitting an existing shard
c#,sql-azure,azure-elastic-scale
Cbattlegear is correct -- the process is not yet integrated into a single tool. Currently the Split/Merge tool only handles the data movement operations. However there is a Powershell example of orchestrating the entire process -- including provisioning the target databases, adding it to the shard map, and invoking the...
Azure Elastic Scale Sharding Key
asp.net,azure,azure-elastic-scale
There is no explicit link between the the sharding key in the SQL schema and its usage (in code). So in the Getting Started sample, the Customers and Orders table both contain a CustomerId column, and you can see that in DataDependentRoutingSample.cs when we access these tables we make sure...