Like every time with a new version of SQL Server, it’s good to see what the new configurations possibilities are for us to manage the instance.

To do this, I will compare SQL 2022 and SQL 2025 using the system view sys.configurations.

I begin with a count(*) to see how many differences I have:

95 configurations for SQL 2022 and 105 configurations for SQL 2025.
Seems that we have 10 new configurations.

Go now to the details with the query on both instances :

SELECT * FROM sys.configurations

I save the result as csv and will see what is double and not:

And finally, I have the 10 new configuration’s possibilities in SQL Server 2025 for the instance:

If I go deeper into these new options, we can already see:

  • ADR cleaner lock timeout (s)
  • SLOG memory quota (%)
    • Default value: 5
    • Description: SLOG memory quota percentage
    • Is dynamic: Yes
    • Is advanced option: Yes
  • max RPC request params (KB)
    • Default value: 5
    • Description: Maximum memory for RPC request parameters (kBytes)
    • Is dynamic: Yes
    • Is advanced option: Yes
  • max UCS send boxcars
    • Default value: 5
    • Description: Maximum number of UCS boxcars for sending messages.
    • Is dynamic: No (need a restart of the SQL Server Engine)
    • Is advanced option: Yes
  • availability group commit time (ms)
    • Default value: 5
    • Description: Configure availability group commit time in milliseconds for SQL Server only. Will be a good configuration for some of our customers…
    • Is dynamic: Yes
    • Is advanced option: Yes
  • tiered memory enabled
    • Default value: 0
    • Description: tiered memory memory-optimized is disabled by default.
    • Is dynamic: No
    • Is advanced option: Yes
  • max server tiered memory (MB)
    • Default value: 2147483647
    • Description: Maximum size of server tiered memory (MB)
    • Is dynamic: No
    • Is advanced option: Yes
  • external rest endpoint enabled
    • Default value: 0
    • Description: Enable or disable invocations of external REST endpoints
    • Is dynamic: Yes
    • Is advanced option: No
  • external xtp dll gen util enabled
    • Default value: 0
    • Description: Enable or disable using external xtp dll generation via HkDllGen.exe
    • Is dynamic: Yes
    • Is advanced option: No
  • external AI runtimes enabled
    • Default value: 0
    • Description: Enable or disable using external AI runtimes
    • Is dynamic: Yes
    • Is advanced option: No

These option are not documented yet on the Microsoft website but it will come soon. here the link to the configurations options:

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-configuration-options-sql-server?view=sql-server-ver17

Of course, we will test these options and have best practices to help our customers to have an optimized SQL Server platform.

See you soon for others blogs… 😉

Post Views: 11
Thumbnail [60x60]
by
Stéphane Haby