Answers to common questions customers ask about a database in SQL Database in the Hyperscale service tier - commonly called a Hyperscale database.
下列儲存考量適用於 Hyperscale:數據記憶體大小上限設定為 128 TB,且無法設定。 您只需支付已配置的資料儲存空間費用,而非針對最大的資料儲存空間。 您不需要支付記錄記憶體的費用。 tempdb 使用本機 SSD 儲存,且其成本已包含在虛擬核心價格中。若要監視 SQL Database 中目前配置和使用的資料儲存大小,請分別使用 ...
Hyperscale 以外のサービス レベルの場合、Azure SQL Database では SQL Server エンジン テクノロジを使用してデータをバックアップおよび復元します。 Hyperscale データベースでは、ストレージ スナップショットに基づいてバックアップと復元が使用されます。 従来の SQL Server バックアッ...
可执行以下 T-SQL 查询:SELECT DATABASEPROPERTYEX ('<database_name>', 'Updateability')。 如果已连接到只读辅助副本,则结果为 READ_ONLY;如果已连接到主要副本,则结果为 READ_WRITE。 必须将数据库上下文设置为你的数据库的名称,而不能设置为 master 数据库的名称。 能否为 HA 次要副本创建专用终结点? 否...
HyperscaleThe Hyperscale service tier is only available in Azure SQL Database. This service tier has a unique architecture because it uses a tiered layer of caches and page servers to expand the ability to quickly access database pages without having to access the data file directly.:::image ...
It is an automated system that allows for replication of data from transactional databases (both SQL Server 2022 and Azure SQL Database) to a dedicated SQL pool in Azure Synapse Analytics. Azure Synapse Link features near real-time analytics, low-code/no-code solutions for replicating data, as...
Advanced Threat Protection for Azure SQL Database is a unified package for advanced SQL security capabilities. It includes functionality for discovering and classifying sensitive data, surfacing and mitigating potential database vulnerabilities, and detecting anomalous activities that could indicate a threat ...
and the amount and speed of storage. The vCore-based purchasing model also allows you to use Azure Hybrid Benefit for SQL Server to gain cost savings.Service tier optionsin the vCore model include General Purpose, Business Critical, and Hyperscale. The service tier generally defines the storage ...
Azure Backup automatically discovers if a selected virtual machine is running SQL and backs up your SQL database natively with support for fifteen-minute recovery time objective (RTO). Azure also provides data resiliency. You can back up important files natively in Azure, with item-level ...
Advanced Threat Protection for Azure SQL Database is a unified package for advanced SQL security capabilities. It includes functionality for discovering and classifying sensitive data, surfacing and mitigating potential database vulnerabilities, and detecting anomalous activities that could ind...