Tuesday 26 April 2016

SQL Considerations

While planning the Configuration Manager 2012 infrastructure you also need to plan the SQL environment. 

Consider the following design rules for you SQL environment:
◆ If you use a remote database server, ensure that the network between the site server and the remote database server is a high-available and high-bandwidth network connection.
◆ Each SMS provider computer that connects to the site database increases network bandwidth requirements. The exact bandwidth is unpredictable because of the many different site and client configurations.
◆ SQL Server must be located in a domain that has a two-way trust with the site server and each SMS provider. Best practice is to place SQL Server in the same domain as the SMS provider and SMS site servers.
◆ Clustered SQL Server configurations for the site database server when the site database is collocated with the site server are not supported.


No comments:

Post a Comment