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: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.

  • 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