locked
DBaaS Azure advantages and disadvantages? Compared to IaaS SQL, PaaS SQL database, PaaS SQL managed instance. RRS feed

  • Question

  • Also just want to confirm Azure has DBaaS (database as a service option).  What type of SQL versions do you have for this SSQL service?  Relational and Nonrelational?    I was reading online that the disadvantage of using this service and is it generally more expensive than a IaaS SQL long term?    And does this service have backups which can be accessed if the DBaaS goes down?  Can the database be accessed if the DBaaS goes offline?

    What is the advantages and disadvantages of DBaaS versus PaaS ( SQL database and SQL managed instance )?

    Does DBaaS allow for multiple databases while also allowing for cross queries (read/write)?   Does it include MS integration services (MSIS)?   How far back in time can backup be kept and at what increments?

    Is it correct that SQL database (PaaS) and SQL Managed Instance only has a month worth of instance in time restores ( Can restore to any minute )?   So how do we keep backups longer?


    dsk

    Thursday, September 12, 2019 6:39 PM

All replies

  • Hi Kimdav111,

    Please see the following documentation to understand all the deployment options but I will also answer the specific questions you have asked:

    Choose the right deployment option in Azure SQL

    Question: Does DBaaS allow for multiple databases while also allowing for cross queries (read/write)? Does it include MS integration services (MSIS)? How far back in time can backup be kept and at what increments?

    Answer: Azure SQL Database will allow for multiple databases on a single (logical) SQL Server instance. Please see: Azure SQL Database Features

    Question: Is it correct that SQL database (PaaS) and SQL Managed Instance only has a month worth of instance in time restores ( Can restore to any minute )?   So how do we keep backups longer?

    Answer: 35 days for short-term backups (single, pooled, and managed instance databases) and 10 years for long-term backups (single and pooled databases only).

    If after reviewing the information provided please let us know if you have additional questions.

    Regards,

    Mike 

    Thursday, September 12, 2019 9:12 PM
  • Please let us know if you have additional questions.

    Thank you!

    Tuesday, September 17, 2019 1:42 AM
  • Answer: Azure SQL Database will allow for multiple databases on a single (logical) SQL Server instance. Please see: Azure SQL Database Features

    My understanding is that Azure Database (PaaS) is a single database hence it states "database"?

    https://en.m.wikipedia.org/wiki/Microsoft_Azure_SQL_Database

    cloud database is a database that runs on a cloud computing platform, and access to it is provided as a service. Managed database services take care of scalability, backup, and high availability of the database. Azure SQL Database is a managed database service which is different from AWS RDS which is a container service.


    dsk

    Monday, September 23, 2019 7:32 PM
  • Hi dsk,

    It is a single database just as a database that exists with a on-premise SQL Server instance is also a single database, where multiple (single) databases can coexist. 

    The terminology can be misleading but if you understand the available SQL Features of each, things become more clear. These are the SQL Database deployment options in Azure from a 'SQL Server' perspective:

    Azure SQL Single Database (link), Azure SQL Database Elastic Pools (link), and Azure SQL Data Warehouse (link)(PaaS)

    • All are deployed to an Azure SQL (Logical) Server and can coexists together.

    SQL Server on an Azure VM (IaaS) (link)

    • Prebuilt image (O/S + SQL Server) and available on Windows or Linux (Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Ubuntu Linux, and Windows Server)
    • You must configure much of what any of the PaaS services listed here provide by default including storage, backup, sizing, etc.

    Azure SQL Managed Instance (PaaS) (link)

    • This is essentially Azure SQL Server (IaaS) but deployed on VM + VNet and considered a PaaS offering because, as you stated, it is provided as-a-service. 
    • Select the desired sizing and all components are deployed as a single, large ARM deployment.

    Azure SQL Database serverless (PaaS) (link)

    • This is a new service in Preview and does not have an accesible SQL Server instance.
    • All interaction is via the Azure Portal or PowerShell and connection string.
    • You can pause a serverless instance for reduced cost (charge for storage only and not compute).

    Additional Information: Choose the right deployment option in Azure SQL

    Generally speaking, an IaaS deployment will be almost 100% to that of an on-premise SQL Server instance. Please let us know if you have additional questions.

    Regards,

    Mike



    Monday, September 23, 2019 10:49 PM