SQL Server hardware config for SharePoint 2013. Server to be physical, rather than virtual.
I need SQL Server hardware configurations for a SharePoint 2013 application. I want SQL Server to be physical. I want to stress the importance, though Microsoft says "Virtualize everything". Please provide: RAM, CPU(cores), Physical/Virtual , network, IOPS required etc details for considering while building a new SharePoint 2013 SQL Server database on new infra.
I would also strongly recommend utilizing a process to benchmark your workload so you know how the physical or virtual server is responding to your SQL server workload. I also think virtualization can be a DBAs friend. If you benckmarks indicate you need more RAM or CPUs you can grab them from the host. If the host doesn't have them you can move the VM over to a different host. There is a free tool called PAL on codeplex that could be a great starting point. It has templates for baselinging HyperV hosts and SQL Server. Basically any Microsoft Server application has a template baked in for specific counters for that applicaton.