首页 > 数据库技术 > 详细

Azure SQL Storage

时间:2021-08-13 17:37:36      阅读:41      评论:0      收藏:0      [点我收藏+]

If you reach the maximum storage, you might get Message 1105 for a managed database or Message 1133 for the instance.

Just like SQL Server, the size of any new database will be based on the size of the model database. The model database is a 100-Mb data file and an 8-Mb log file. Also like SQL Server, the size of model is configurable. You can alter the size and the number of files, but you don‘t have control over the physical location of them. Microsoft has commitments on I/O performance based on your deployment choice. Additionally, because remote storage is used in the General Purpose service tier, the data file and log file size can affect performance.

For Azure SQL Database, there is a possible maximum size of database files based on your chosen SLO. You choose a Data max size up to this possible maximum size. Maxsize for database files (as defined by the sys.database_files.max_size column) can grow to Data max size.

The Azure SQL Database Hyperscale tier is different from the other service tiers in that it creates a database that‘s initially 40 GB and grows automatically in size to the limit of 100 TB. The transaction log has a fixed size restriction of 1 TB.

 

Azure SQL Storage

原文:https://www.cnblogs.com/jade0702/p/15137893.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!