How to choose the correct SQL Server destination on Azure

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
(gentle upbeat music) - [Shreya] Like I mentioned, we are going to take a look at what are your different SQL Server migration options, and Azure SQL deployment options. And choosing between these options, deployment options. Choosing a particular tier, and then we'll quickly look at a Demo. Which shows you a very easy interface of how to pick one of these options. - [Host] You're also going to show a Demo as well? - [Shreya] Yeah. - [Host] That's fun. - [Shreya] I'm going to show a Demo. All right, so quickly jumping into, what are your different SQL Server migration options available to you when you are trying to upgrade or migrate your SQL Server from one version to another. So, there are two basic ways in which you can migrate your SQL Server, current SQL Server. Either you decide to upgrade and modernize to Azure, and you bring your workload to Azure. - [Host] Move to cloud? - [Shreya] Exactly. Or you just decide to modernize on premises. And you just decide to upgrade from a older version of SQL Server to a newer version of SQL Server, which is SQL Server 2017 or SQL Server 2019. - [Host] 2019 coming up now? - [Shreya] Yes. - [Host] That's very exciting. - [Shreya] Pretty soon. So. If you are a end of US customer, end of service customer. You can either upgrade to a new version or you can continue to use your EOS Server, with the help of ESU. Upgrades you can purchase those on-prem. Or when you come to Azure and you decide to modernize to Azure, and you bring your workload to VM, let's say. You get those ESU updates for free on Azure VMs. Or you can decide to just upgrade and come to Managed Instance or Azure SQL DB. And then you never have to worry about any upgrades in future. So looking well. Let's dive deep into all of these options. So let's assume that you have decided to upgrade to Azure, and modernize to Azure. - [Host] Of course. - [Shreya] And once you have decided to modernize to Azure. There are multiple options that are available to you. And the first one is SQL Server virtual machines. So you want to bring your workload to Azure, but you want control over the OS, you want control over the SQL Server, and database server. Complete control. Then this is a good option for you. - [Host] Okay. - [Shreya] Another one is SQL Managed Instances. Wherein you don't want to manage the hardware, you don't want to manage the OS, you don't want to manage the database, you want Azure to manage all for you. But you want SQL Server level access and you want network access. Like, you want to make a v-net with your on-prem network and then you want to control access to that network. So Managed Instance is a good option. And the third one is SQL Databases, Azure SQL Databases. If you are trying to modernize. It's basically for modern cloud applications, right? When you create a database, you can easily scale it up, scale it down. It's easy to provision and it's for the modern workloads, modern cloud applications typical. And SQL Database also provides you a way to scale all the way up to 100 terabytes and beyond. And it also lets you use options like Serverless. Where you can save some costs by not paying for compute, when you're not using it. - [Host] I see. You can pause in a way? - Yeah. You can pause in a way and then save some cost that way. - [Host] That's awesome. - And there is another option. Elastic Pools. Where you can share the resources and save some cost that way also. All right. - Especially on these deployment options. Let's say it shows something. I want all the deployment options, can you please talk about those? And also if you have some real world examples. You can talk about those, as well. - Yeah, sounds good. So like I mentioned there are three different options available to you. But then when to choose what, right? That's often source of confusion for a lot of customers. So let's say you want to manage your SQL server. You want OS level control, you want SQL server level control, and you want to control everything. And so SQL Server Virtual Machine is, like I mentioned, is a good option. And SQL server virtual machine typically customers also use it when they have features, they are using features like DTC and polybase. Which are not available in Azure SQL Database, so then it becomes a natural choice for them. And also if you want to run SSIS, SSAS, SSRS type of applications. - [Host] Integration services, analysis services or reporting services? - [Shreya] Exactly. Co-locate it with your SQL Server or you want to run a third party application, and you want to co-locate with SQL Server on Azure. Then SQL Server VMs are a good option for you. And H&R Block is one of our customers, who recently migrated their workload to SQL Server on VMs and SQL server 2017. And that was their first step of migration. And now they are looking to migrate to SQL Server Managed Instances, as their next step of migration. So once you migrate to Azure, it opens up the different ways of, you know, modernizing your application and continuously evolving them. Now let's discuss SQL Server Managed Instances. And Managed Instances is something that you would choose when you want 100% surface area compatibility with SQL server. So you get full compatibility of features, and you also get some control over network. So you are allowed to create, you are able to create a v-net, and then you are able to control access to your Managed Instance through that v-net. Access, allow applications or allow users that you want to. Komatsu is a customer who recently migrated to SQL Server Managed Instance. They brought about 1.5 terabytes of data to Managed Instance. - [Host] I see, that's cool. - [Shreya] And they observed 49% cost savings, by migrating to Managed Instance, and 25% performance benefits. - [Host] Fantastic. - [Shreya] When migrating to Cloud. So they are a great, great example of Managed Instance migration. Now, you just want a database. You don't want to deal with server or instance level, and you want database. You want it to be fully managed. So Managed Instance also is fully managed by Azure. So you get actually all and everything, all those benefits by default, right. On SQL Database also you get all these benefits by default. It's completely managed by Azure. You just have to create a database. Spin it up, dial it up or down, according to your workload requirements. It's very easy. Provisioning is easy, very straight forward. And it has simple deployment cycles, right. Thompson Reuters is one such customer who picked Azure SQL Database recently. Because for the e-billing application, and they picked it because of fast provisioning, and easy scale up and scale down of Azure SQL Database. - [Host] I see. - [Shreya] Now if you have a application, which is multi-tenant. When you want to host multiple databases, maybe you are selling a product to your customers, and for each of the customer you want to host a database, in Azure SQL DB. - [Host] Like a retail scenario? - Like a retail scenario. So you would. There is an option available for you, which is Elastic Pools. Azure SQL DB Elastic Pools, which where you can host a multi-tenant application, and this lets you share resources among the databases. So when you do that, you can also observe some cost savings for you. So it's a good option for those type of people, and Paychex is one such example. Who actually hosted their payment and time management software on Azure SQL Database. And they are able to scale to tens of thousands of hundreds of thousands of customers with the help of this Azure SQL Elastic Pool migration that they did. - I see. So the next question now, is because what tier do I choose? If I let's say I wanna go for this right here. - Yeah, that's helpful. Like people always ask that. So we have multiple tiers available in Cloud for Azure SQL DB Managed Instance, general purposes, business critical and Hyperscale. Hyperscale is available only for SQL DB. For SQL DB and Elastic Pool we have both DTU and vCore models available. Which let you choose. vCore model is basically specially, it provides a flexibility to choose between compute and storage. And with hyperscale in Azure SQL DB, you can scale very easily. You scale up and down very quickly. It's very fast. All the way up to 200 terabytes or more. And in general purpose here for Single or Elastic Pools we also give you our serverless option now. Which lets you save on your compute cost. Like I mentioned before, if you're not using it. So I think Ajay is going to discuss talk about this more in detail later. And with that I am going to just quickly give you a demo of how these all different options are available to you on Azure, when you go to Azure. And how you can choose between all of these. - [Host] All right. - So let's quickly switch to my demo screen here, and here I just have my Azure portal open. And when I come here I can go to my favorites, and now you have this new experience available to you. A new resource type available to you, just called Azure SQL -- - [Host] So hold on. So when people go to portal.azure.com, How do they get to this screen? Let's start really from scratch then. - [Shreya] Yeah so this is your portal.azure.com. You come here, you see this and you see all these resource types here. Different resource types. So if you have not seen Azure SQL before, the only resource types that you would see is probably SQL databases, SQL Managed Instances, if you have put them in favorites or virtual machines, right. And you can say create a resource here, and if you type Azure SQL you will see a new resource type, Azure SQL, right. So I have put it in my favorites, so I see it here. - [Host] Okay, now I understand. - So if I click on Azure SQL, it actually shows me it puts all the resource types together into one place now. So it actually shows me all my databases, all my VMs, and all my Managed Instances at one place. So that way I know exactly how many resources I am using. And what all resources I have. So now let's say if I have to, I want to add a new resource here, right? So if I click on add, it now tells me that there are these three different type of Azure SQL resources available to me. The first one is SQL Databases. Where I can pick between single database, or elastic pool, or a hyperscale, or a serverless. You know, different options. And the other one is Managed Instance. Where I get network level control. So I can set up my own v-net, and the third one, of course, is SQL Virtual Machines. Where I can bring my SQL server version from on-prem to Cloud, as is. And like I mentioned, the Eos I can take benefit of the ESU. Updates for next three years for free on Azure. So it's a great option for customers looking to quickly migrate. So yeah these are three different options available and customers can quickly get started with their migrations from with the help of these options. - That's awesome. Thank you so much for all this great information, Shreya. - Thank you, thank you for having me here. - All right folks, we'll be right back with our next segment with Ajay . Please don't go away.
Info
Channel: Microsoft SQL Server
Views: 6,629
Rating: undefined out of 5
Keywords: Azure SQL, Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs, SQL Server, Azure migration, database migration, cloud, Azure SQL DB, SQL Server virtual machines, Serverless, Azure SQL Elastic Pool, Sanjay Soni, Microsoft, Shreya
Id: PjfZPNWRtHg
Channel Id: undefined
Length: 12min 21sec (741 seconds)
Published: Thu May 28 2020
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.