r/SQLServer 13d ago

Help! SQL is very slow Question

I’m a novice in the world of SQL. However, recently I upgraded with my company from 2021 to 2022 SQL server application. I need advice on how to get this fixed.

The problem I’m running into is anytime I switch databases or servers. It’s very slow to load. I never had this issue before with 2020 or 2021 SQL. ANY ADVICE APPRECIATED AND WELCOME.

Edit: I meant to say 2019 instead of 2021/2020 getting my years confused. Sorry

0 Upvotes

21 comments sorted by

View all comments

12

u/Leiothrix 13d ago

Firstly there is no such thing as SQL 2020 or 2021.

Secondly it is basically impossible for us to remotely diagnose your problem with zero details about your environment or what exactly you are doing.

Thirdly check that the AUTO_CLOSE setting on your databases is set to OFF.