SQL Server 2019 on Windows 11 AMD Ryzen 9000 - Very Slow on localhost

asked 2021-11-07T20:48:36.227+00:00
Kristijan G 1 Reputation point

I am facing an issue with SQL Server 2019 both Express & Developer version. I am not even sure this in a correlation with AMD Ryzen, but it is for sure connected with Windows 11. I'll explain why.

I've bought this laptop in July and ever since I installed SQL Server, I am facing extremely slow performance on any SQL operation (Select Table, Edit Table, Select Database, execute Query, etc.). When I got the laptop, Windows 10 Pro was preinstalled. After my personal investigation, I manage to fix this lagging issue by following this article: https://www.surfacetablethelp.com/2016/05/fix-slow-response-sql-connection-network-in-windows-10.html

Few weeks ago, I've updated my windows 10 to windows 11 and once again, I am facing the same problem all over again. I checked to see if during installation process previous steps (from the article) were deleted/overrode but no. All the changes I've made in windows 10 were/are still present. Again, I started to search online for any tip/solution, but so far nothing really helped.

Until now, I've used SQL server on localhost only (no remote connections whatsoever). Delays I am taking about are relatively small, but if you are using SQL queries and checking/updating tables all the time, it stars to be boring very fast for you to wait and wait.

I am using SSMS. Also tried Azure Data Studio, but the problem is still present.

FYI - I am using PC too with an AMD processor on Windows 10 and everything works smoothly since day one.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,460 questions
{count} votes

4 answers

Sort by: Most helpful
  1. answered 2021-11-07T22:24:20.12+00:00
    Erland Sommarskog 67,481 Reputation points Microsoft MVP

    I see that you have the RTM version or SQL 2019. This can explain why it talks about Windows 10 - Windows 11 had not been invented at that time.

    You should download and install the most recent Cumulative Update, which is CU13. I cannot promise that this resolves the issues you are seeing, but at this is a build that - I presume - is aware of Windows 11.


  2. answered 2021-11-07T22:45:51.35+00:00
    Kristijan G 1 Reputation point

    Both actually. But I just checked with a colleague of mine from work, he literally has the same process as I do and the same laptop and windows brand, just different model.

    He has no issues with poor performance and query "SELECT @@version" shows Windows 10 Pro as a result to him as well.


  3. answered 2021-11-16T00:07:42.093+00:00
    Kristijan G 1 Reputation point

    Finally, some good news. I've just reinstalled windows 11 and first program I've installed was SQL Server and SSMS. And FINALLY, everything works smooothly.

    I think all of my problems are solved :)


  4. answered 2022-02-23T23:26:40.717+00:00
    Kristijan G 1 Reputation point

    SOLUTION

    After changing multiple different machines, Windows and SQL versions, I finally manage to discover what was the source of my problem.

    Long story short, it was all about the Windows authentication.

    177317-image.png

    On the first picture, I used Windows authentication and the connection was very slow, but once I changed it to the SQL Server Authentication and entered credentials which I set up during the installation process, all those lag/delay issues were gone.

    At that time, I've started digging what could be the problem. Finally, the solution was:

    • open this file in notepad/notepad++ as an ADMINISTRATOR C:\Windows\System32\drivers\etc
    • add this line 127.0.0.1 KRISTIJAN-TRLEN but replace this ** KRISTIJAN-TRLEN** with your SQL server name. You can check your SQL server name by executing this query SELECT @@SERVERNAME

    After adding this line, everything was working smoothly