Microsoft SQL 2025 Standard

What is included in Microsoft SQL 2025 Standard?

Database Engine – Full relational engine for production transactional workloads.
Vector Search – Native vector type for AI similarity queries.
Native JSON – Stored JSON type with indexing and validation.
Resource Governor – Now in Standard, caps CPU and TempDB usage.
Basic Availability Groups – Two-replica, single-database high availability only.
Core Capacity – Limited to lesser of 4 sockets or 32 cores.

What are the main benefits of Microsoft SQL 2025 Standard?

Microsoft SQL Server 2025 Standard is the mid-tier edition of Microsoft's relational database, built for business applications that need a reliable engine without Enterprise-level scale. The 2025 release raises Standard's ceiling to 32 cores and 256 GB of buffer pool memory and adds AI-era features such as native vector search.

Higher Limits – Memory cap doubled from 128 GB to 256 GB.
More Cores – Core ceiling raised from 24 to 32.
Flexible Licensing – Choose Per Core or Server plus CAL.
AI Workloads – Run vector similarity search inside the engine.
Report Server – Power BI Report Server included without Software Assurance.
TempDB Control – Resource Governor now limits runaway TempDB usage.

SQL Server 2017 - 2025 Buying guide: How to understand license models, CALs and choose the right SQL product
How to read the Per Core and Server plus CAL models and pick the right SQL Server product for your setup.

What does Microsoft SQL 2025 Standard do?

Microsoft SQL 2025 Standard stores, queries, and protects relational data for line-of-business applications, ERP systems, and reporting back ends. The 2025 engine adds a native vector data type with approximate vector indexes, so similarity search for AI and retrieval features runs directly in the database instead of a separate vector store. It also brings native JSON storage, regular expressions in T-SQL, and the ability to call external REST endpoints from a stored procedure. For an administrator, this means fewer middleware layers between the application and the data when building search or AI-assisted features on an existing SQL estate.

How does SQL 2025 Standard compare to the Enterprise edition?

The main difference is scale and high availability: Standard is capped at the lesser of 4 sockets or 32 cores and 256 GB of buffer pool memory, while Enterprise scales to the operating system maximum. Standard supports only Basic Availability Groups, which cover two replicas and a single database per group, whereas full Always On Availability Groups with multiple readable secondaries remain Enterprise-only. Standard also omits Enterprise-only performance features such as online index rebuild, batch mode on rowstore, and automatic tuning. For most departmental databases and mid-sized applications under 32 cores, Standard covers the needed feature set; databases requiring multi-database failover groups or large in-memory workloads should be checked against Enterprise before buying.

SQL Server 2017 to 2025 Comparison: Differences, features, editions, support, upgrade, and license selection
Side-by-side look at editions, feature differences, and support across the SQL Server 2017 to 2025 releases.

What is the difference between a User CAL and a Device CAL for SQL 2025 Standard?

A User CAL covers one named person who can access SQL Server from any number of devices, while a Device CAL covers one device that any number of people can use to access the server. These CALs only apply under the Server plus CAL model, which is available for Standard but not Enterprise. CALs are required even when access is indirect through middleware or pooling, since multiplexing does not reduce the count. As a rule of thumb, Server plus CAL stays cheaper than Per Core until you pass roughly 30 users; above that, Per Core usually wins because it needs no CALs at all.

SQL Server 2017 to 2025 FAQ: Frequently Asked Questions About Standard, Enterprise, and CALs
Common buyer questions on Standard versus Enterprise differences and when CALs are actually required.

What are the core licensing minimums for SQL 2025 Standard?

Under the Per Core model, you must license a minimum of 4 cores per physical processor, and core licenses are sold in two-core packs. You license every physical core on the server, so a server with more than four cores per socket must be fully covered. Per Core licensing requires no CALs and allows unlimited users, which makes it the practical choice for public-facing applications where user counts cannot be tracked. Check your actual socket and core count before buying, because a common mistake is sizing licenses to the minimum when the host has more physical cores that must all be licensed.

SQL Server 2017-2025: Core licensing, minimum requirements and avoiding incorrect purchases
How core minimums per processor and per server work, and the sizing mistakes that lead to wrong purchases.

What technical limitations should users know before buying SQL 2025 Standard?

Standard caps the buffer pool at 256 GB and compute at 32 cores, and its columnstore segment cache and memory-optimized data are each limited to 32 GB regardless of installed RAM. It does not include full Always On Availability Groups, online index rebuild, or the Enterprise intelligent query processing features such as automatic tuning and batch mode on rowstore. High availability on Standard is restricted to Basic Availability Groups (two replicas, one database) and two-node failover clustering. If your workload needs multiple readable secondaries, a single failover group spanning several databases, or in-memory data sets larger than 32 GB, those requirements push you to Enterprise.

What changed for Reporting Services in SQL 2025 Standard?

Starting with SQL Server 2025, on-premises reporting is consolidated under Power BI Report Server, and the right to run it is now included with Standard core licenses without requiring Software Assurance. In earlier versions this benefit was tied to Enterprise with active SA, so 2025 Standard buyers who need on-premises paginated reports gain access they did not have before. Note this applies only to SQL Server 2025 licenses; SQL Server 2022 or earlier licenses keep the old rules. Publishing shared reports still requires a separate Power BI Pro user license.

Frequently asked questions about Microsoft SQL 2025 Standard

Does SQL 2025 Standard require Client Access Licenses?

Only if you license under the Server plus CAL model. Under Per Core licensing, no CALs are needed and any number of users or devices may connect. Standard is the only edition that still offers the Server plus CAL option.

Is the Web edition still available in SQL Server 2025?

No. SQL Server 2025 Web edition was discontinued, so the available paid editions are Standard and Enterprise. Organizations that previously used Web edition need to move to Standard or Enterprise.

What is the maximum database size in SQL 2025 Standard?

The maximum relational database size is 524 PB, the same as Enterprise. In practice, the real ceiling for Standard workloads is the 32-core and 256 GB memory limits rather than the database file size.

Can I run vector and AI search on SQL 2025 Standard?

Yes. SQL Server 2025 introduces a native vector data type, vector functions, and approximate vector indexes, and these are available in Standard. This lets you build similarity search and AI-assisted retrieval directly against your existing database without a separate vector store.