Answers to common questions customers ask about a database in SQL Database in the Hyperscale service tier - commonly called a Hyperscale database.
Premium- and Memory Optimized Premium-series hardware for Azure SQL Database Hyperscale Based on the latest generation of Intel® Xeon Scalable processors (3rd gen –“Ice Lake”) and AMD EPYC™ 7763v (“Milan”) chipsets, this Premium-series hardware offers signif...
このデータは、単一データベースおよびプール レベルのエラスティック プールについて、sql_instance_cpu_percent および sql_instance_memory_percent Azure Monitor メトリックによって報告されます。注意 sql_instance_cpu_percent とsql_instance_memory_percent のAzure Monitor のメトリックは、...
ディザスター リカバリー操作の一環として、またはドリル、再配置などの他の理由で、Azure SQL Database の Hyperscale データベースを、現在ホストされているリージョン以外のリージョンに復元する必要がある場合、主な方法として、データベースの geo リストアを実行します。 geo リストアは...
(RBPEX) local disk cache for each compute replica in serverless Hyperscale are gradually reclaimed if CPU or memory usage are low enough for long enough. When workload activity returns, disk IO may be required to rehydrate data pages into the SQL buffer pool memory cache o...
Primary Hyperscale databases hosted in the primary elastic pool share the SQL Server database engine (sqlservr.exe) compute process, vCores, memory, and SSD cache. Configuring high availability for the primary pool creates additional high availability pools that contain read-only database replicas for...
1Learn more about Azure reservations and Azure SQL Database reserved capacity pricing. Compute is provisioned in virtual cores (vCores). A vCore represents a logical CPU offered with an option to choose between compute generations. Storage In the Hyperscale tier, you are charged for storage for...
1Learn more aboutAzure reservationsand Azure SQL Databasereserved capacitypricing. Compute is provisioned in virtual cores (vCores). A vCore represents a logical CPU offered with an option to choose between compute generations. Storage In the Hyperscale tier, you are charged for storage for your ...
Azure SQL Database (SQL DB) Documentation Overview Quickstarts Tutorials Concepts Single databases Elastic pools Logical servers Serverless In-memory OLTP in Azure SQL Database Hyperscale Purchasing models Connectivity Local development Security Business continuity ...
(akaDAGin NoSQL world) and executing it. It will take into account data size, data distribution, index availability, memory, concurrency and time constraints and it will generate an execution plan that likely is the best possible given all aforementioned constraints. All this is possible as in ...