The SQL Server role is responsible for the site server database, so if the SQL Server goes down, the site server and other roles cannot write or read data from the database. Microsoft SQL Server has different forms of high availability, but Configuration Manager only supports Microsoft SQL Cluster. But we need to configure this before we start installing Configuration Manager.
There are multiple ways we can set up this cluster but I have chosen to set it up using SMB 3-based storage. Since the release of Windows Server 2012, it is now supported to place SQL databases on SMB 3 shares. Instead of having shared storage directly attached to the SQL servers, we set up file server which has the storage attached and set up the file server with SMB shares which the SQL Servers will access.