When we were working on performance baseline or performance improvement we might be clearing down the procedure cache to get the exact statistics of the stored procedure. Many of them are already aware how to do it in hosue SQL Server. We might be using anyone of the below command to clear the procedure cache. Continue reading Clear Procedure Cache in SQL Azure database
It’s been a week I was playing around this new feature. Now I’m going to drop\disable this feature so save some $ in my Azure subscription 🙂 Continue reading SQL Server 2016 – Drop \ Disable Database \ Table Stretch Feature
I started testing the stretch tables quite some time and thought of blogging the experience. Continue reading SQL Server 2016 – Playing Around Stretch database
In the last two days we saw whats stretch database and how to identify the tables. Today we will see how to stretch your database to Azure cloud. Before we start I would like mention it again that the tables you choose for streching will migrate all the data to Azure which means we can stretch only the archieve tables so dont just blindly add all the tables. Just include only the required archieve tables. Continue reading SQL Server 2016 – Configure Database Stretching
Yesterday I covered what’s strecthing a database to cloud. Today I’m going to cover how to identify the tables which can stretch to Cloud. In most of the cases you knew which table we can move however if you are not sure when one then you can make use of this tool. I’m going to use one of the famous tool used in assessment before SQL Server upgrade to new version. Yes you are right, it’s SQL Server upgrade advisor!!