Skip to content

Commit 0835c3d

Browse files
jovanpop-msftjovanpop-msft
authored
Updated Managed Instance intro
1 parent e5d83de commit 0835c3d

File tree

1 file changed

+33
-61
lines changed

1 file changed

+33
-61
lines changed

‎articles/sql-database/sql-database-managed-instance.md

+33-61
Original file line numberDiff line numberDiff line change
@@ -18,7 +18,7 @@ ms.date: 10/01/2018
1818
Azure SQL Database Managed Instance is a new deployment model of Azure SQL Database, providing near 100% compatibility with the latest SQL Server on-premises (Enterprise Edition) Database Engine, providing a native [virtual network (VNet)](../virtual-network/virtual-networks-overview.md) implementation that addresses common security concerns, and a [business model](https://azure.microsoft.com/pricing/details/sql-database/) favorable for on-premises SQL Server customers. Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, Managed Instance preserves all PaaS capabilities (automatic patching and version updates, [automated backups](sql-database-automated-backups.md), [high-availability](sql-database-high-availability.md) ), that drastically reduces management overhead and TCO.
1919

2020
> [!IMPORTANT]
21-
> For a list of regions in which Managed Instance is currently available, see [Migrate your databases to a fully managed service with Azure SQL Database Managed Instance](https://azure.microsoft.com/blog/migrate-your-databases-to-a-fully-managed-service-with-azure-sql-database-managed-instance/).
21+
> For a list of regions in which Managed Instance is currently available, see [supported regions](sql-database-managed-instance-resource-limits.md#supported-regions).
2222
2323
The following diagram outlines key features of the Managed Instance:
2424

@@ -35,30 +35,42 @@ To decide between Azure SQL Database Single Database, Azure SQL Database Managed
3535
Azure SQL Database Managed Instance combines the best features that are available both in Azure SQL Database and SQL Server Database Engine.
3636

3737
> [!IMPORTANT]
38-
> A Managed Instance runs with all of the features of the most recent version of SQL Server, including online operations, automatic plan corrections, and other enterprise performance enhancements.
38+
> A Managed Instance runs with all of the features of the most recent version of SQL Server, including online operations, automatic plan corrections, and other enterprise performance enhancements. A Comparison of the features available is explained in [Feature comparison: Azure SQL Database versus SQL Server](sql-database-features.md).
3939
4040
| **PaaS benefits** | **Business continuity** |
4141
| --- | --- |
4242
|No hardware purchasing and management <br>No management overhead for managing underlying infrastructure <br>Quick provisioning and service scaling <br>Automated patching and version upgrade <br>Integration with other PaaS data services |99.99% uptime SLA <br>Built in [high-availability](sql-database-high-availability.md) <br>Data protected with [automated backups](sql-database-automated-backups.md) <br>Customer configurable backup retention period (fixed to 7 days in Public Preview) <br>User-initiated [backups](https://docs.microsoft.com/sql/t-sql/statements/backup-transact-sql?view=azuresqldb-mi-current) <br>[Point in time database restore](sql-database-recovery-using-backups.md#point-in-time-restore) capability |
4343
|**Security and compliance** | **Management**|
4444
|Isolated environment ([VNet integration](sql-database-managed-instance-vnet-configuration.md), single tenant service, dedicated compute and storage) <br>[Transparent data encryption (TDE)](https://docs.microsoft.com/sql/relational-databases/security/encryption/transparent-data-encryption-azure-sql)<br>[Azure AD authentication](sql-database-aad-authentication.md), single sign-on support <br>Adheres to compliance standards same as Azure SQL database <br>[SQL auditing](sql-database-managed-instance-auditing.md) <br>[Threat Detection](sql-database-managed-instance-threat-detection.md) |Azure Resource Manager API for automating service provisioning and scaling <br>Azure portal functionality for manual service provisioning and scaling <br>Data Migration Service
4545

46-
## vCore-based purchasing model
46+
The key features of Managed Instance are shown in the following table:
47+
48+
|Feature | Description|
49+
|---|---|
50+
| SQL Server version / build | SQL Server Database Engine (latest stable) |
51+
| Managed automated backups | Yes |
52+
| Built-in instance and database monitoring and metrics | Yes |
53+
| Automatic software patching | Yes |
54+
| The latest Database Engine features | Yes |
55+
| Number of data files (ROWS) per the database | Multiple |
56+
| Number of log files (LOG) per database | 1 |
57+
| VNet - Azure Resource Manager deployment | Yes |
58+
| VNet - Classic deployment model | No |
59+
| Portal support | Yes|
60+
| Built-in Integration Service (SSIS) | No - SSIS is a part of [Azure Data Factory PaaS](https://docs.microsoft.com/azure/data-factory/tutorial-deploy-ssis-packages-azure) |
61+
| Built-in Analysis Service (SSAS) | No - SSAS is separate [PaaS](https://docs.microsoft.com/azure/analysis-services/analysis-services-overview) |
62+
| Built-in Reporting Service (SSRS) | No - use PowerBI or SSRS IaaS |
63+
|||
4764

48-
The [vCore-based purchasing model](sql-database-service-tiers-vcore.md) gives you flexibility, control, transparency, and a straightforward way to translate on-premises workload requirements to the cloud. This model allows you to scale compute, memory, and storage based upon their workload needs. The vCore model is also eligible for up to 30 percent savings with the [Azure Hybrid Use Benefit for SQL Server](../virtual-machines/windows/hybrid-use-benefit-licensing.md).
65+
## vCore-based purchasing model
4966

50-
A virtual core represents the logical CPU offered with an option to choose between generations of hardware.
51-
- Gen 4 Logical CPUs are based on Intel E5-2673 v3 (Haswell) 2.4 GHz processors.
52-
- Gen 5 Logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz processors.
67+
The [vCore-based purchasing model](sql-database-service-tiers-vcore.md) in Managed Instance gives you flexibility, control, transparency, and a straightforward way to translate on-premises workload requirements to the cloud. This model allows you to scale compute, memory, and storage based upon your workload needs. The vCore model is also eligible for up to 30 percent savings with the [Azure Hybrid Use Benefit for SQL Server](../virtual-machines/windows/hybrid-use-benefit-licensing.md).
5368

54-
The following table helps you understand how to select the optimal configuration of your compute, memory, storage, and I/O resources.
69+
In vCore model, you can choose between generations of hardware.
70+
- **Gen 4** Logical CPUs are based on Intel E5-2673 v3 (Haswell) 2.4 GHz processors, attached SSD, physical cores, 7GB RAM per core, and compute sizes between 8 and 24 vCores.
71+
- **Gen 5** Logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz processors, fast eNVM SSD, hyper-threaded logical core, and compute sizes between 8 and 80 cores.
5572

56-
||Gen 4|Gen 5|
57-
|----|------|-----|
58-
|Hardware|Intel E5-2673 v3 (Haswell) 2.4 GHz processors, attached SSD vCore = 1 PP (physical core)|Intel E5-2673 v4 (Broadwell) 2.3 GHz processors, fast eNVM SSD, vCore=1 LP (hyper-thread)|
59-
|Compute sizes|8, 16, 24 vCores|8, 16, 24, 32, 40, 64, 80 vCores|
60-
|Memory|7 GB per vCore|5.5 GB per vCore|
61-
||||
73+
Find more information about the difference between hardware generations in [Managed Instance resource limits](sql-database-managed-instance-resource-limits.md#hardware-generation-characteristics).
6274

6375
## Managed Instance service tiers
6476

@@ -77,32 +89,11 @@ The following list describes key characteristic of the General Purpose service t
7789

7890
- Design for the majority of business applications with typical performance requirements
7991
- High-performance Azure Premium storage (8 TB)
80-
- 100 databases per instance
92+
- Built-in [High-availability](sql-database-high-availability.md#standardgeneral-purpose-availability) based on reliable Azure Premium Storage and [Azure Service Fabric](../service-fabric/service-fabric-overview.md)
8193

82-
The following list outlines the key characteristics of the General Purpose service tier:
94+
For more information, see [Stogate layer in General purpose tier](https://medium.com/azure-sqldb-managed-instance/file-layout-in-general-purpose-azure-sql-managed-instance-cf21fff9c76c) and [Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose)](https://blogs.msdn.microsoft.com/sqlcat/2018/07/20/storage-performance-best-practices-and-considerations-for-azure-sql-db-managed-instance-general-purpose/).
8395

84-
|Feature | Description|
85-
|---|---|
86-
| Number of vCores* | 8, 16, 24 (Gen 4)<br>8, 16, 24, 32, 40, 64, 80 (Gen 5)|
87-
| SQL Server version / build | SQL Server Database Engine (latest stable) |
88-
| Min storage size | 32 GB |
89-
| Max storage size | 8 TB |
90-
| Max storage per database | Determined by the max storage size per instance |
91-
| Expected storage IOPS | 500-7500 IOPS per data file (depends on data file). See [Premium Storage](../virtual-machines/windows/premium-storage-performance.md#premium-storage-disk-sizes) |
92-
| Number of data files (ROWS) per the database | Multiple |
93-
| Number of log files (LOG) per database | 1 |
94-
| Managed automated backups | Yes |
95-
| HA | Data stored in Azure Storage and [Azure Service Fabric](../service-fabric/service-fabric-overview.md) |
96-
| Built-in instance and database monitoring and metrics | Yes |
97-
| Automatic software patching | Yes |
98-
| VNet - Azure Resource Manager deployment | Yes |
99-
| VNet - Classic deployment model | No |
100-
| Portal support | Yes|
101-
|||
102-
103-
\* A virtual core represents the logical CPU offered with an option to choose between generations of hardware. Gen 4 Logical CPUs are based on Intel E5-2673 v3 (Haswell) 2.4 GHz processors and Gen 5 Logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz processors.
104-
105-
For more information, see [Standard/General Purpose availability and architecture](sql-database-high-availability.md#standardgeneral-purpose-availability) in Azure SQL Database and [Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose)](https://blogs.msdn.microsoft.com/sqlcat/2018/07/20/storage-performance-best-practices-and-considerations-for-azure-sql-db-managed-instance-general-purpose/).
96+
Find more information about the difference between service tiers in [Managed Instance resource limits](sql-database-managed-instance-resource-limits.md#service-tier-characteristics).
10697

10798
### Business Critical service tier (preview)
10899

@@ -111,34 +102,15 @@ Business Critical service tier is built for applications with high IO requiremen
111102
The following list outlines the key characteristics of the Business Critical service tier:
112103
- Designed for business applications with highest performance and HA requirements
113104
- Comes with super-fast SSD storage (up to 1 TB on Gen 4 and up to 4 TB on Gen 5)
114-
- Supports up to 100 databases per instance
115-
- Built-in additional read-only instance that can be used for reporting and other read-only workloads
105+
- Built-in [High availability](sql-database-high-availability.md#premiumbusiness-critical-availability) based on [Always On Availability Groups](https://docs.microsoft.com/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server) and [Azure Service Fabric](../service-fabric/service-fabric-overview.md).
106+
- Built-in additional [Read-only database replica](sql-database-read-scale-out.md) that can be used for reporting and other read-only workloads
116107
- [In-Memory OLTP](sql-database-in-memory.md) that can be used for workload with high-prefrmance requirements
117108

118-
|Feature | Description|
119-
|---|---|
120-
| Number of vCores* | 8, 16, 24, 32 (Gen 4)<br>8, 16, 24, 32, 40, 64, 80 (Gen 5)|
121-
| SQL Server version / build | SQL Server (latest available) |
122-
| Additional features | [In-Memory OLTP](sql-database-in-memory.md)<br> 1 additional read-only replica ([Read Scale-Out](sql-database-read-scale-out.md))
123-
| Min storage size | 32 GB |
124-
| Max storage size | Gen 4: 1 TB (all vCore sizes)<br> Gen 5:<ul><li>1 TB for 8, 16 vCores</li><li>2 TB for 24 vCores</li><li>4 TB for 32, 40, 64, 80 vCores</ul>|
125-
| Max storage per database | Determined by the max storage size per instance |
126-
| Number of data files (ROWS) per the database | Multiple |
127-
| Number of log files (LOG) per database | 1 |
128-
| Managed automated backups | Yes |
129-
| HA | Data stored in local SSD and use [Always On Availability Groups](https://docs.microsoft.com/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server) and [Azure Service Fabric](../service-fabric/service-fabric-overview.md) |
130-
| Built-in instance and database monitoring and metrics | Yes |
131-
| Automatic software patching | Yes |
132-
| VNet - Azure Resource Manager deployment | Yes |
133-
| VNet - Classic deployment model | No |
134-
| Portal support | Yes|
135-
|||
136-
137-
For more information see [Premium/Business Critical availability and architecture](sql-database-high-availability.md#premiumbusiness-critical-availability) in Azure SQL Database.
138-
139109
> [!IMPORTANT]
140110
> The **Business Critical** service tier is in preview.
141111
112+
Find more information about the difference between service tiers in [Managed Instance resource limits](sql-database-managed-instance-resource-limits.md#service-tier-characteristics).
113+
142114
## Advanced security and compliance
143115

144116
Azure SQL Database Managed Instance combines advanced security features provided by Azure cloud and SQL Server Database Engine.

0 commit comments

Comments
 (0)