Share via

DBCC CHECKDB throttle SQL on Azure VM .

sakuraime 2,351 Reputation points
2021-02-28T02:39:58.91+00:00

Are there any cases that doing DBCC CHECKDB on SQL on Azure VM throttle the VM by IO ?

Azure Virtual Machines
Azure Virtual Machines

An Azure service that is used to provision Windows and Linux virtual machines.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,431 Reputation points Microsoft External Staff
    2021-03-01T06:10:41.957+00:00

    Hi @sakuraime ,

    While running SQL Server on Azure Virtual Machines, we recommend that you continue using the same database performance tuning options that are applicable to SQL Server in on-premises server environments.

    Check if below links could help you.

    Minimizing the impact of DBCC CHECKDB : DOs and DON'Ts
    Performance guidelines for SQL Server on Azure Virtual Machines


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    Was this answer helpful?

    0 comments No comments

Your answer

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