Best Practices
• Highly consider SQL database mirroring for high availability and disaster recovery.
• Ensure that network links are at least 1Gb and ideally have less than 1ms of latency (possibly up to 10ms in some scenarios) if using synchronous database mirroring. In addition, make sure there are no spikes in WAN traffic and ensure that there are guaranteed levels of service on the network links.
• Be sure that the hardware of the SQL principal and mirror servers are equivalent and ideally identical.
• For the best overall data security for a SharePoint environment, use SSL Certificates for client traffic to SharePoint, use IPsec for communications between farm servers, and use SQL TDE for encryption in storage.
• Use a separate SQL instance ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access