---
id: post/demiliani-com/12820
type: post
title: Dynamics 365 Business Central on-premises and SQL Server 2025.
summary: SQL Server 2025 introduces significant improvements for Dynamics 365 Business Central on-premises environments, including higher resource limits for Standard Edition, enhanced columnstore indexes, improved locking and query optimization, persistent statistics on secondary replicas, AI capabilities, and Fabric mirroring support.
tier: community
language: en
tags:
  - sql server 2025
  - on-premises
  - performance optimization
  - columnstore indexes
  - high availability
  - ai capabilities
  - sql upgrades
system: platform
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:58:17.935Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 2c251223c0eef814a58264d794d88539629e6f6599e91cc56da9ff4bd14ee323
evidence:
  - kind: blog
    url: https://demiliani.com/2025/11/19/dynamics-365-business-central-on-premises-and-sql-server-2025/
    title: Dynamics 365 Business Central on-premises and SQL Server 2025.
    date: "2025-11-19"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://demiliani.com/2025/11/19/dynamics-365-business-central-on-premises-and-sql-server-2025/
    title: Dynamics 365 Business Central on-premises and SQL Server 2025.
    date: "2025-11-19"
    commit: null
    t: null
    quote: With SQL Server 2025, statistics are now preserved on secondary replicas, even after a restart or failover.
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "12820"
source_id: demiliani-com
source_name: Stefano Demiliani
url: https://demiliani.com/2025/11/19/dynamics-365-business-central-on-premises-and-sql-server-2025/
published_at: "2025-11-19T11:00:59.000Z"
author: Stefano Demiliani
full_text: false
words: 418
quotes:
  - text: With SQL Server 2025, statistics are now preserved on secondary replicas, even after a restart or failover.
    why_it_matters: Eliminates a common cause of performance degradation in high-availability BC configurations after failover events
code_objects_mentioned: []
systems:
  - platform
  - administration
versions_mentioned:
  - SQL Server 2025
  - SQL Server 2024
  - SQL Server 2016
  - SQL Server 2014
preview:
  embeddable: true
  frame_url: https://demiliani.com/2025/11/19/dynamics-365-business-central-on-premises-and-sql-server-2025/embed/
  image: https://demiliani.com/wp-content/uploads/2025/11/bc_sql2025.png
  image_alt: null
  image_w: 579
  image_h: 257
  site_name: Stefano Demiliani
  favicon: https://demiliani.com/wp-content/uploads/2022/09/sd_wordpress_logo.png?w=32
  probed_at: "2026-10-07T11:51:20.388Z"
---

# Dynamics 365 Business Central on-premises and SQL Server 2025.

[Read the post](https://demiliani.com/2025/11/19/dynamics-365-business-central-on-premises-and-sql-server-2025/) · Stefano Demiliani (Stefano Demiliani, MVP) · 2025-11-19 · 418 words · tier community · reviewed (checked by Opus)

> SQL Server 2025 introduces significant improvements for Dynamics 365 Business Central on-premises environments, including higher resource limits for Standard Edition, enhanced columnstore indexes, improved locking and query optimization, persistent statistics on secondary replicas, AI capabilities, and Fabric mirroring support.

## Key points

- SQL Server 2025 Standard Edition raises limits to 32 CPU cores and 256 GB RAM, up from 24 cores and 128 GB
- Ordered columnstore indexes can be built or rebuilt online; online ordered clustered builds sort in tempdb, which can help queries but slow the build
- Optional Parameter Plan Optimization chooses plans from runtime parameters, easing parameter sniffing problems
- Statistics now persist on secondary replicas after restart or failover, avoiding rebuilds
- Adds AI endpoint calls, vector types and search, and Fabric mirroring; in-place upgrade is supported from SQL Server 2014, and 2016 support ends in 2026

## Quotes

- "With SQL Server 2025, statistics are now preserved on secondary replicas, even after a restart or failover." (Eliminates a common cause of performance degradation in high-availability BC configurations after failover events)

## Context

- Features: SQL Server 2025 Standard Edition resource limits, Ordered nonclustered columnstore indexes, Online columnstore index creation, Optional Parameter Plan Optimization (OPPO), Improved locking management, Persistent statistics on secondary replicas, Vector data type and functions, Fabric mirroring with change feed capability
- Versions: SQL Server 2025, SQL Server 2024, SQL Server 2016, SQL Server 2014

Source: Stefano Demiliani, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.