Forum Discussion

LukaszA685's avatar
LukaszA685
Copper Contributor
Sep 02, 2021

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:...
olafhelper's avatar
olafhelper
Bronze Contributor
Sep 03, 2021
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

  • LukaszA685's avatar
    LukaszA685
    Copper Contributor
    Sep 09, 2021

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

Resources