SQL server with Trace flags 2371 and 7745

Sanjeev K 20 Reputation points
2024-12-20T10:18:09.9266667+00:00

Hi Team,

We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes required after migrations.
Please share any links for Azure Managed instace with 2371 and 7745 info.

Azure Database Migration service
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,214 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
542 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Mahesh Kurva 1,470 Reputation points Microsoft Vendor
    2024-12-20T20:03:50.1166667+00:00

    Hi @Sanjeev K,

    Welcome to the Microsoft Q&A and thank you for posting your questions here.

    i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes required after migrations. Please share any links for Azure Managed instace with 2371 and 7745 info.

    Azure SQL Managed Instance, you generally won’t need to manually enable Trace Flags 2371 and 7745, as their functionalities are managed automatically in the managed environment.

    Trace Flag 2371: User's image

    Trace Flag 7745:

    User's image

    Here are the links for trace flag 2371 and trace flag 7745: Trace flags.

    Hope this helps. Do let us know if you have any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.