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

pmscorca 877 Reputation points
2024-01-13T18:20:37.2333333+00:00

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

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,821 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,203 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
189 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tianyu Sun-MSFT 28,941 Reputation points Microsoft Vendor
    2024-01-15T09:13:45.02+00:00

    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.

    1 person found this answer helpful.
  2. Pinaki Ghatak 2,795 Reputation points Microsoft Employee
    2024-01-13T18:31:28.4133333+00:00

    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!