Ever heard of Microsoft SQL Stretch Database? No… You should really check it out! Basically you can extend your OnPremise database towards Azure. By doing this, you can offload cold data whilst still being able to query it if needed.
How does it look in reality?
Enabling it is quite easy… In the SMMS, just right click on the database. Select “Tasks”, “Stretch” and “Enable”.
Now run through the wizard and you are set! Please do remember that this feature isn’t exactly cheap…
And afterwards you can follow-up your state via monitoring.
There are quite some limitations when using this feature. Be sure to check them out before embarking on your journey! If you don’t do this, you’ll end up seeing a screen like this… Where all, or a big majority of, the tables have been grayed out.
The nice icon indicates that the tables are not compatible with “Stretch Database”…
Proactively identifying those compatibility issues
If you want to identify those compatibility issues beforehand, I would suggest you run the “Stretch Database Advisor” from the “Upgrade Advisor“-tool. This will analyze your database and identify compatibility issues!
Otherwise you can keep on guessing what went wrong… 😉
- Stretch Database is a hybrid way that enables you to offload cold data to Azure
- This implementation has its limitations
- Do a compatibility test beforehand by using the “Stretch Database Advisor”