question

sri6438 avatar image
sri6438 asked

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.
sharepoint
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
I haven't done any virtualisation but, from reading and listening to podcasts, I get the impression there aren't many servers you can't virtualise these days. As long as the organisation doesn't buy underpowered hardware. There's no free lunch here. As for the specs, I think it depends on your expected workload. Estimating this is likely to need quite a bit of information about the volume of shared files and the intensity of user activity. Here are some resources that should get you started: [ http://www.informit.com/articles/article.aspx?p=2131832&seqNum=3][1] [ https://technet.microsoft.com/en-us/library/cc262485.aspx][2] [1]: http://www.informit.com/articles/article.aspx?p=2131832&seqNum=3 [2]: https://technet.microsoft.com/en-us/library/cc262485.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnSterrett avatar image
JohnSterrett answered
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. http://pal.codeplex.com
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.