Business Critical

In the Ultra Transcenders books

AZ-305

Each book explains Business Critical in context, with comparison tables and the common traps.

Terms in this definition

• Auditing

  Azure SQL capability that sends database audit logs to Log Analytics, Event Hubs or a storage account; that account is allowed to be in a different region.

• Archive

  Offline access tier for blobs, cheapest to store yet dearest to access. Reading a blob means rehydrating it first, which can take as long as 15 hours.

• LSDOU

  The sequence in which Group Policy is processed: the local policy first, followed by site, domain and organisational unit policies. The nearest, last-processed setting takes effect unless Enforced or Block Inheritance alters that.

• SSD

  Flash-based solid-state storage that underpins Premium disks and storage.

• Zone-redundant

  Distributed over every availability zone in a region, allowing it to withstand losing one zone; a StandardV2 NAT gateway is an example.

• Serverless

  Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.

Related terms

• General Purpose

  An Azure SQL service tier that pairs a single compute node with remote storage. Compared with Business Critical it has higher latency and lacks a synchronous replica.

• Memory-optimized table

  An In-Memory OLTP table held entirely in RAM, giving very fast access with no latching. SCHEMA_AND_DATA makes it durable and SCHEMA_ONLY doesn't. Azure SQL Database offers it on Business Critical and Premium only.

• MySQL Flexible Server

  Option for running Azure Database for MySQL. Burstable lacks zone-redundant high availability, which is available only on the General Purpose and Business Critical tiers.

• Read scale-out

  On Premium or Business Critical tiers of Azure SQL, sends read-only connections to a readable secondary replica; there is no load balancing.