Azure Database – Service Tiers–Performance

In this Post we can explore the Advantage of SQL Database Tiers Scalability.

Scalability

Azure provides Flexibility of Scaling Up/Down based on the Demand. 

Create a Database

Create an Azure Database with Default Options.  You will get it created in Standard service tier.

image

Performance Test

You can create a Table with 10 columns & Insert 10 Lakh Records.

It took around 2 hour for me.

Scale Up

Now we need to Scale Up and Test.

Choose the database Configuration as shown below.

image

In the appearing window choose Premium.

Choose the 500 DTU option.  Now click Apply button.  Wait for Few minutes for the Upgrade to complete.

image

DTU

DTU represents Data Throughput Unit. More the DTU More the Performance.

Run the Results

Now run the same Query again.  The performance got improved by 50% by completing in 1 hour.

Summary

Increasing the Service Tier / DTU will give quick jump up in performance during Peak hours.

Note

Do not forget to scale down after the purpose. Else the bills will also perform huge.

2 thoughts on “Azure Database – Service Tiers–Performance

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s