Specification
Database Management System - Relational Database Engine
High-Performance Query Processing with T-SQL Support
Azure Integration (Azure Synapse Link, Microsoft Purview, Azure SQL Managed Instance)
Advanced Security Features (Always Encrypted, Transparent Data Encryption, SQL Ledger)
Basic High Availability (Always On Failover Clusters, Basic Availability Groups)
Supports Up to 2 Nodes for Availability Groups
Maximum 4 Sockets or 24 Cores per Instance
128 GB Buffer Pool Memory Maximum
32 GB Allocated for Columnstore and In-Memory OLTP Data
Degree of Parallelism Limited to 2 for Standard Edition
Row-Level Security and Dynamic Data Masking
Columnstore Indexes for Analytics and Reporting
Query Store and Intelligent Query Processing Features
Backup and Recovery Tools
License Type: Server + CAL or Core-Based Licensing
Supported on Windows Server 2016, 2019, 2022; Windows 10, Windows 11
Minimum 6 GB Hard Disk Space Required
Minimum 4 GB RAM Required