Azure SQL托管实例中的最小磁盘大小 [英] Smallest disk size in Azure SQL Managed Instance

问题描述

根据浏览所有SQL数据库定价选项  我可以使用32GB的磁盘启动Azure SQL数据库托管实例.

As per Explore all SQL Database pricing options  I can start a Azure SQL Database managed instance with 32GB disk. 

但是根据在数据库文件较小的存储空间和

Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose) smallest disk (BLOB) I can put my data/log files is 128GB. Quote the the 2nd URL "The system will use 128 GB (P10) blobs even for very small database files, to avoid negative performance impact that would be likely with smaller blob sizes (P4 and P6)".

如果我不能将最小的数据/日志文件放在小于128GB的blob中，那么使用32GB磁盘启动托管实例的目的是什么.

If I cannot put smallest data/log file in smaller than 128GB blobs, what is the purpose of starting a managed instance with 32GB disk.

推荐答案

嗨Taiob，

Hi Taiob,

据我了解，定价页面上引用的32GB仅代表定价信息-数据库大小的前32GB.

as far as I understand, the 32GB referenced on the pricing page represents the pricing information only - for the first 32GB of your database size.

根据 https://docs.microsoft.com/zh-CN/azure/sql-database/sql-database-managed-instance-transact-sql-information

As per https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-transact-sql-information

"每个受管实例最多为Azure高级磁盘空间保留35 TB的存储，并且每个数据库文件都放置在单独的物理磁盘上.磁盘大小可以是128 GB，256 GB，512 GB，1 TB或4 TB. 磁盘上未使用的空间不收费."

"Each Managed Instance has up to 35 TB storage reserved for Azure Premium Disk space, and each database file is placed on a separate physical disk. Disk sizes can be 128 GB, 256 GB, 512 GB, 1 TB, or 4 TB. Unused space on disk is not charged."

hth
Marcin

hth
Marcin

这篇关于Azure SQL托管实例中的最小磁盘大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！