Currently I am working on a project that requires me to consolidate 3 servers into 1 server, so I am trying to find the best method at the moment. Right now my options are:
- Consolidate the 3 servers into 1 separate server and set up a high availability cluster on it
- Consolidate the 3 servers into an existing server that already has a clustered environment.
As of now, I am leaning towards the 1st option because the existing server currently holds over 40 databases and performance wise, I don't think it will be a good idea to add more databases into it. I was also told to use perfmon to look at cpu, memory, disks, etc. but I'm still trying to understand how to use it efficiently.
This is my first time working with server/database consolidation in SQL server, so I'm not sure where exactly I can find pros and cons to those 2 options. It'll be very helpful if I can get an answer to guide me where and what I should look at to compare those 2 options! Thank you in advance!
Screenshots of some analysis are below if that helps.
Note: The 2 nodes in the cluster server are synchronized and the 3rd node is asynchronous.