05
Azure SQL Database Managed Instance separates compute and storage
components. You can select compute nodes with 8, 16, or 24 cores and
Azure Premium Disk Storage. Azure SQL Database Managed Instance uses
the same Azure SQL Database infrastructure that organizations have been
using for billions of transactions daily. The only difference is that Azure SQL
Database Managed Instance provides your organization with the entire SQL
Server instance—instead of individual databases—while preserving PaaS
capabilities. It's a fully-managed SQL Server instance in the Azure cloud, using
the same SQL Server database engine, and it incorporates the latest features,
performance improvements, and security patches.
You'll need to create a virtual network, and then place your database in Azure
SQL Database Managed Instance inside the virtual network. From there, it
will work as a private SQL Server instance on Azure. All databases within that
instance are positioned on the same SQL Server instance, which gives you
consistent functionality like global temp tables, cross-database queries, SQL
Server Agent, and so on. All other server-level objects, such as sign-ins or
SQL Server Agent sign-ins, are appropriately replicated in the environment.
Multiple managed instances are grouped in a virtual cluster that can be placed
in a virtual network (VNet) and isolated from the public internet. These
virtual clusters provide capabilities for cross-instance queries and Service
Broker messaging.
Chapter 04 How will it work for me?
04
How will it work for me?
05