SQL Server
Another important role to configure redundant is SQL Server.
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 ...
Get Microsoft System Center Configuration Manager High availability and performance tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
