Hi guys

I have a customer and they want to know how to adopt those capabilities on Azure.

1. Elastic Scale for Azure SQL Database by Automation configuration.

It looks the Automation functionality has been go-live for a while on Global Azure, do you know when will it be landed off in China? If not be schedule, does it have any alternative to implement the same scale-up/down by a bunch of configuration?

2. Shard Elasticity for Azure SQL Database by PowerShell scripting.

I once urged for whether Microsoft support team or Partner can provide any pragmatic approach that could scale-up/down SQL Database performance driven by PowerShell scripting.

Scenario:

We have a mobile-facing application backed by Azure SQL Database and currently have 50+ users on the system for couple of months without issue. We have done some performance testing and found that acceptable performance for the base load activity can be provided with S1. However customer will provide import file once a day (usually afternoon) with up to 130,000+ records to be compared and updated, to complete these imports within an acceptable time period (< 25 minutes) this will require a P1 performance level.

For customer the cost of maintaining a P1 performance level database exceeds the planned subscription fee. We want to have a look at dynamically increasing the performance for 1 to 2 hours while the imports are processed. This would allow the imports to be processed in an acceptable timeframe while keeping costs to a minimum.

Does any existing scripting/solution exist for the scenarios above exist?

Thank you!

--Sky

• Edited by horizonsky Monday, December 22, 2014 3:22 PM