Description
Sometimes query execution in VSCode-mssql is very slow, lags for 10-20s before anything happens. I'm pretty sure it's not my database being slow because the exact same query in SQL Server Studio never experiences the same slowness. It seems to happen with any query, I haven't been able to narrow it down to one specific query or one specific table, it seems to happen pretty much across the board. It happens randomly, it's not every single time, haven't been able to identify a pattern.
While the slowness happened, I noticed it says "Getting definition... Executing query" in the status bar at the bottom, may or may not be related.
I also see no way to cancel the query when this happens.
Specs :
Windows 11 pro 24H2
VSCode 1.99.3
mssql extension v. 1.31.0
sqlserver : Microsoft SQL Server 2019 (RTM-CU30) (KB5049235) - 15.0.4415.2 (X64)
There is nothing intersting logged in the Output panel when this happens. I see this but at first glance I don't think it's related.
[Error - 10:42:15 AM] Request textDocument/completion failed.
Message: Sequence contains no matching element
Code: 0
