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 ...
Get Microsoft SharePoint 2010 Unleashed 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.
