Giant Azure SQL Databases

Okay it is not really called Giant Azure SQL Database but its close. There is a new public preview vCore service tier called Hyperscale. The architecture behind this is very different to that of a Standard tier SQL database (as an example).  What drives this concept? Flexible storage architecture where you can scale out the storage as your database grows (up to the 100TB mark).

Please read the following link for in depth details of how this works: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-hyperscale

Obviously the main reason to go down this route is to go beyond the limit of 4TB HOWEVER there are 2 main caveats to be aware of which I have found so far.

  1. This does NOT  support TDE (Transparent Data Encryption) enabled databases. So if you have a requirement to have TDE enabled then this is not the option for you.

Here is a screen shot of the Azure Portal with the red exclamation warning.

tdewatrning

2. You cannot use this feature with a database within an elastic pool.

As you can see with the image below I issued a scale request to hyperscale from a database that was within a standard elastic pool.

iscaled

Then I noticed the”Not Supported” message for the elastic pool from the main menu page.

notsupported

I can 100% confirm that the database was moved out of the pool as the scale option completed.

poolpeak

So whilst looking into new features always check for caveats and carry out some research.

Thanks for reading.

 

2 thoughts on “Giant Azure SQL Databases

  1. Pingback: Dew Drop - October 4, 2018 (#2817) - Morning Dew

  2. Pingback: Dew Drop - October 8, 2018 (#2818) - Morning Dew

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