O'Reilly logo

Microsoft System Center Configuration Manager High availability and performance tuning by Marius Sandbu

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required