Microsoft Azure now available from UK datacenters

Today, I’m proud that Microsoft is first global provider to deliver the complete cloud from datacenters in the UK. Microsoft Azure, along with Office 365, is now generally available from multiple UK datacenter locations providing data residency to help enable the digital transformation of our customers in industries such as banking, government, public sector and healthcare that require certain data to remain within the UK.

As one of the largest cloud operators in the world, we’ve invested billions in building a highly scalable, reliable, secure, and sustainable cloud infrastructure. With the introduction of new regions in the UK, Microsoft has now announced 34 Azure regions around the world with 28 generally available today – more than any other major cloud provider.

Customers choosing Microsoft benefit from the company’s experience in enterprise computing and hybrid cloud – offering everything from optimization of compute resources to higher-level services for advanced analytics, media services, the Internet of Things (IoT), and big data.

Microsoft Azure is a growing collection of integrated cloud and data services—analytics, computing, databases, mobile, media, networking, storage, and web—for moving faster, achieving more and saving money.

You can learn more about the customers adopting the Microsoft Cloud at Official Microsoft Blog.
Quelle: Azure

Improved Automatic Tuning boosts your Azure SQL Database performance

Azure SQL Database is the world’s first intelligent database service that learns and adapts with your application, enabling you to dynamically maximize performance with very little effort on your part.

Today we released an exciting update to Azure SQL Database Advisor that greatly reduces the time (from a week to a day) required to produce and implement index tuning recommendations. 

This brings us one step closer to our vision where developers no longer have to worry about physical database schema management, as the system will self-optimize to provide predictable and optimal performance for every database application.

About SQL Database Advisor

Database Advisor provides custom performance tuning recommendations for your databases using machine learning intelligence. It saves you time, automatically tuning your database performance, so you can focus your energy on building great applications.

Database Advisor continuously monitors your database usage and provides recommendations to improve performance (create/drop indexes, and more)
You can choose to have the recommendations be automatically applied (via Automatic Tuning option)
Recommendations applied or rolled back manually (via Azure Portal or REST API)

What’s new in this release?

The following table summarizes the improvements in this release:

Area
Before
Now

Time to produce new index recommendations
(for a database with daily usage)
~7 days
~18 hours

Delay before T-SQL statement is executed
(CREATE INDEX or DROP INDEX)
~12 hours delay
Immediately
(starts within minutes)

Time to react to any regressions and revert “bad” tuning actions
~12 hours
<=1 hour

Delay between implementing consecutive index recommendations
~12 hours delay between indexes
Immediately
(starts within minutes)

TOTAL TIME TO IMPLEMENT
(for a DB with 3 active recommendations)
~9 DAYS
~1 DAY

Automated Index Tuning is now even more powerful

All these improvements together make automated index tuning an even more attractive choice for managing the performance of your Azure SQL databases. With the new recommendation models and greatly improved underlying automation, Database Advisor will tirelessly work 24/7 to make your database applications run blazing fast at all times.

If you’re not using automated tuning yet, we strongly encourage you to give it a try – you’ll be pleasantly surprised with the results, as many of our other customers already were.

Summary

You can now run your production DB workload in SQL DB for a day, and Database Advisor will help you improve your database performance by providing custom tuning recommendations. You can also opt-in to automated tuning mode where the tuning recommendations will be auto-applied to your database for a complete hands-off tuning experience.

Now you can dedicate your energy and attention on building great database applications, while the SQL DB service keeps your databases running and performing great for you.

Next steps

If you’re new to Azure SQL Database, sign up now for a free trial and discover how built-in intelligence of Azure SQL DB make it easier and faster than ever to build amazing database applications.

If you’re already using Azure SQL Database, try SQL Database Advisor today and share your feedback with us using the built-in feedback mechanism on the Azure Portal, or in the comments section of this post. We’d love to hear back from you!

For more detailed information, check out the SQL Database Advisor online documentation.
Quelle: Azure