Slow queries - DevOps 2019

[LukaszA685]

Slow running queries.

TFS Version:
Patch 17.153.31402.4 found in registry, it is installed.

SELECT @@VERSION
Microsoft SQL Server 2019 (RTM-CU12) (KB5004524) - 15.0.4153.1 (X64) Jul 19 2021 15:37:34 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: )

256 GB RAM (204800 MB RAM max used by SQL Server)
24 logical processors: Intel® Xeon® CPU E5-2667 0 @ 2.9GHZ

The inquiry takes several minutes.
In an environment that is several times worse, such a query takes several seconds.

The query syntax in the private part of the message below.

[#2]

---

The query syntax in the private part of the message below.

---

@LukaszA685 , where; I can't see any query here?

Anyway, check the execution plan of the query to see if suitable indexes are used to fetch the data.

Olaf

[#3]

@olafhelper The problem was solved by raising the compatibility level to the highest value (150).