Sep 01 2021 11:46 PM
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.
Sep 03 2021 01:13 AM
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
Sep 09 2021 06:17 AM
@olafhelper The problem was solved by raising the compatibility level to the highest value (150).