[Bug]: Issues with IntelliSense

[croblesm]

Description

Every now and then IntelliSense becomes unresponsive. Sometimes I see messages like Getting definition or Updating InstelliSense but the process itself never finishes and I'm forced to reload VS Code.

I noticed that there is certain delay on this process while switching databases hosted in Azure. Here is what I see:

Some comments I found in multiple sources:

stop it freezing, on the frequent restarts we have to do stop it taking ages updating intellisense
Constantly has to reconnect to server and the Intellisense is very poor.
It takes an incredibly long time to get schema definitions for intellisense / autocompletion.
I don't know why but intellisense keeps dropping ever since these latest updates. very interesting.
IntelliSense does not work well with Database Projects (many wrong error messages).
Intellisense when connected to database sometimes lags and takes a while to update
intellisense is inconsistent

Steps to Reproduce

1. Connect to an Azure / Local database
2. Open query editor
3. Check InstelliSense status in VS Code's status bar

Affected Area

• Connection dialog (SQL Server | Azure browse/Fabric browse)
• Query editor
• Query results panel
• Object Explorer
• GitHub Copilot integration
• Preview/Edit data
• Table Designer
• Schema Designer
• Schema Compare
• Local SQL Server Container provisioning
• SQL database in Fabric provisioning
• DACPAC/BACPAC export/import
• SQL Database projects
• Query Plan Visualizer
• Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

• VS Code: Latest (Insiders)
• MSSQL version: v1.43 RC
• macOS: Latest (Tahoe)

Confirmation

• I have searched existing issues and couldn't find a match
• I want to work on this issue