SQL Server connections slow after in-place upgrading to 2025 from 2022

Quiring, Peter 20 Reputation points
2026-06-20T18:11:11.66+00:00

We are experiencing slow connections to SQL 2025 after doing in-place upgrade from 2022.

Connections taking ~ 900ms

SQL authentication (not Windows auth).

Tried to add -T4671 startup parameter as found in another topic but no effect.

SQL Server Database Engine

Answer accepted by question author
Erland Sommarskog 137.5K Reputation points MVP Volunteer Moderator
2026-06-20T19:28:42.56+00:00

This happens because a combination of several factors. One is a security enhancement in SQL 2025, so that password-based authentication uses PBKDF2, which means that the password is hashed 100000 times. The other factors is due to bad practice on your side:

  • Using SQL authentication.
  • Turning off connection pooling.

This feature was originally introduced in SQL 2022 CU12, but in SQL 2022, you had to enable it with a trace flag. The very same trace flag you tried to use to disable the feature. Well, in early builds of SQL 2025, the trace flag did indeed disable PBKDF2, but that was of course a very bad idea, since sites who had enabled the feature in SQL 2022, would suddenly have it disabled in SQL 2025.

My recommendation is that you enable connection pooling. I would also recommend that you ask yourself why you are using SQL authentication.

If you think that this is not an option for you, your best bet is to open a support case and argue that the business impact is of the magnitude that you need a trace flag.

Was this answer helpful?

3 people found this answer helpful.

0 additional answers

Sort by: Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.