Database schema analysis continuously in progress for a database project in Visual Studio

Question

Hi, I'm developing a database project with Visual Studio 2022 and SSDT extension. After some scripts created I've noticed that Visual Studio runs more slowly because a database schema analysis is in progress, reading the message shown in the status bar: the database projects are ready after the completion of some thousands of operations. Is it possible to disable a such analysis at design time in order to work in Visual Studio without any slowdowns? Thanks

Answer 1

Hello @pmscorca ,

Welcome to Microsoft Q&A forum.

Do these three settings work(Disable code analysis - .NET Framework projects)? Please right-click you project > Unload Project > right-click it again > Edit Project File > add three lines into one of the property groups > right-click your project > Reload Project.

Besides, please try to right-click your project > Properties > Project Settings > uncheck Validate casing on identifiers option.

Other options maybe also work: right-click your project > Properties > Project Settings > Database Settings… > Operational > uncheck Auto create statistics and Auto update statistics options. Refer to documents: AUTO_CREATE_STATISTICS option, and AUTO_UPDATE_STATISTICS option.

BTW, database schema analysis runs by default, it has reasons. Actually, I don’t suggest changing/unchecking some specific options. If it’s very slow on your side, you may send feedback here: SQL or here: Developer Community - Visual Studio.

Sincerely,

Tianyu

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hello @pmscorca

Yes, it is possible to disable the database schema analysis in Visual Studio 2022 to avoid slowdowns. Here are the steps to do so:

1. Right-click the project node in Solution Explorer and select Properties.
2. Select the Code Analysis tab.
3. To disable source analysis at build time, uncheck the Run on build option.
4. To disable live source analysis, uncheck the Run on live analysis option.

Please note that starting in Visual Studio 2022 version 17.0.4, if you prefer the on-demand code analysis execution workflow, you can disable analyzer execution during live analysis. You may also look into using Azure Data Studio, for SSDT projects. The SQL Database Projects extension in Azure Data Studio provides a project-based development environment compatible with SQL Server, Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse SQL. It allows you to create a new project from a connected database, edit a project by adding or removing objects (tables, views, stored procedures) or custom scripts in the project, and more. However, please note that the SQL Database Projects extension requires the .NET SDK for project build functionality. I hope this helps!