Forum Discussion
Slow queries - DevOps 2019
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:...
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
olafhelper The problem was solved by raising the compatibility level to the highest value (150).