none
how to change instance size Azure SQL RRS feed

  • Question

  • We are having some challenges with determining how to change the instance size of our Azure Hosted SQL.  Right now it's a Premium P2.  We're looking at possibly changing to vCore, but we're not sure how P2 compares to which set of choices for vCore.  Also, we're not sure which of the offerings within that. Can anyone provide more information on how to guide customers from the DTU model to vCore?  Will the DTO model become deprecated in the future and replaced with vCore?

    Suggestions please.

    Friday, December 6, 2019 7:23 PM

All replies

  • Here is an official document

    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-to-vcore

    Also

    https://www.gigxp.com/azure-sql-dtu-to-vcore-migration/


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, December 8, 2019 5:18 AM
  • Hi Tekbloke,

    There is a msft rule saying 100 DTUs = 1 Vcore. The thing is that you have general purpose or business critical (more performance but more expensive as well) options that you also need to check. If you have software assurance you can move your license to this object as well (Make sure that if you change the service tier enable this benefit on the portal or using powershell!!). The first answer to this? Well test this in a lower environment with the same queries and the same number of users. One of the things also is to use the latest compatibility level to use the latest features in sql 2019 like Accelerated database recover or the new features in inteligent query processing (batch mode in row store o memory grant feedback among others....).

    Hope this helps!

    Sunday, December 8, 2019 7:42 PM
  • According to the documentation (see Uri's response) a P2 corresponds to AT LEAST 2 vCores.This also maps to the Business Critical tier (the corresponding tier to Premium).

    This is only a rule of thumb and you should then look at the performance of your queries to identify whether additional resources are needed.


    Martin Cairney SQL Server MVP

    Monday, December 9, 2019 4:14 AM
  • Just checking in to see if the above answer(s) helped. 

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread . 
    And, if you have any further query do let us know. 
    Tuesday, December 10, 2019 8:39 AM
    Moderator