I have 2 clients who are running into some clustering issues, and recently NICs on different servers of the same cluster failed. Each client runs following infrastructure:
Windows 2008 R2 cluster conformed by 3 physical nodes. OS is Windows 2008 R2, SQL version 2008
Windows 2012 R2 cluster with 3 physical nodes. OS is WIndows 2012 R2 SQL version is 2012
All machines are physical, run in a Windows 2008 R2 forest and domain functional level
My questions are:
What are the recommended hotfixes to deploy on Windows 2008 R2 and 2012 R2 physical cluster for SQL?
What are the best practices and recommended settings for NICs on all the 3 nodes?
What are the recommended settings for building the cluster following MS best practices?
This client runs multiple SQL instances, any thoughts?
Your feedback is highly appreciated