<ul data-eligibleForWebStory="true"><li>SQL Server 2025 introduces new instance configuration possibilities compared to SQL Server 2022.</li><li>There are 10 new configurations in SQL Server 2025, bringing the total to 105.</li><li>A query on sys.configurations was used to identify the differences between the two versions.</li><li>New configurations include ADR cleaner lock timeout, SLOG memory quota, max RPC request params, max UCS send boxcars, availability group commit time, tiered memory enabled, max server tiered memory, external rest endpoint enabled, external xtp dll gen util enabled, and external AI runtimes enabled.</li><li>The configurations have default values and details provided along with whether they are dynamic or require a restart.</li><li>These new options are not yet documented on the Microsoft website but are expected to be added soon.</li><li>Testing and best practices will be conducted to optimize the SQL Server platform.</li><li>For more detailed configurations options, refer to the Microsoft website linked in the article.</li></ul>

SQL Server 2025: What news on the instance configuration

Discover more