Best recommendations for SQL server 2008 on a VMWare ESXi Box.
Posted on 2011-10-06
I know there is a lot of info out there regarding this topic, but a lot of it is very generalized and I wanted to give you specific hardware specs that we have and what we are trying to accomplish.
I currently have a sql server 2008 on a VM via an iSCSI SAN. the Disk I/O is average at best. So we are deciding to put that VM on its own ESXi Server. The server is a dual quad core processor with 8-10k SAS drives in a Raid 10 array.
My question is, should I do anything in particular to squeeze out the best performance from the Raid-10? Should I create a different size array? How should I set up the partitions? Thanks for the advice...