I am starting to plan a migration of SQL Server 2008 R2 Enterprise Ed. to 2017 (edition TBD). One of the more important tasks assigned to me is to determine the specs for the new VMWare hardware my employer will be purchasing.
To do so, I need gather information about the current workload (on Windows Server 2008 R2 SP1 with SQL failover clustering on 5+ year-old hardware) and translate that to virtualized performance on new hardware - a VMware host which will use SQL Server 2017 and, probably, Availability Groups.
I've set up a PerfMon data collector based off of a blog post by David Klee ( link ) which will start tonight at midnight as a starting point but am still trying to wrap my head around the analysis...
i.e. "How do I take the PerfMon results from the workload running on the old hardware and translate that into requirements for new hardware ?".
Apart from PerfMon what are my other options for right-sizing the new hardware?