Share via

SQL FCI cluster with 2 nodes and one cloud witness and storage is S2D, total database is over 70TB

Shi, Hui 1 Reputation point
2025-02-19T05:43:25.5366667+00:00

hi folks:

We are a VLDB shot with over 70TB using SQL FCI with 2 nodes plus a cloud witness. The pain is

around patching. Every time after patching, before reboot the node, we have to put into disk maintenance mode as per recommendation from MSFT. However it automatically triggered the repair job. For database with 70+ TB, we have to wait hours before we can simply reboot the node ?

Questions:

  1. Why can't we just skip this as only drain the node ? I've checked many places and there is no official document supporting but a few docs hinted that os level patching / sql server patching may not require disk maintenance mode.
  2. What's the downside if we simply go ahead rebooting the node while repairing job is in progress? Wouldn't this a scenario covered by HA which we pay the money for? Thanks Hui
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,490 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
1,027 questions
Windows Server Storage
Windows Server Storage
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Storage: The hardware and software system used to retain data for subsequent retrieval.
669 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 30,901 Reputation points
    2025-02-20T01:27:10.2933333+00:00

    Hi @Shi, Hui

    Wouldn't this a scenario covered by HA which we pay the money for?

    It is suggested to open a ticket to Microsoft support and the engineers will help to resolve the issue.

    Services Hub (microsoft.com)

    Best regards,

    Cosmog

    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".

    0 comments

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.