Topics started by AlPM

1 Topic

A
AlPMVoyager
asked in AHV Virtualization

Disk layout for Vmware SQL 2016 Guest Cluster

Hello all I'm trying to establish the optimal disk layout for a VMware MS SQL 2016 2 node guest failover cluster that will have a single SQL instance hosting multiple small to medium sized databases. Unfortunately we don't really have the funds for licensing to do the recommended approach of creating lot of small VMs to host these databases, so we need to consolidate where possible. I've been reading though the Nutanix SQL 2016 best practice guide and it's raised a few questions. I've decided to allocate multiple vdisks specifically for database files, so I'd have a few database files to each vdisk instead of one vdisk with all the database files on it. I'm assuming this approach might be better due to each vdisk having a 6GB Oplog allocation and so more vdisks would prevent a single oplog from quickly over filling? Is there any there real a benefit here to having more vdisks to spread the databases across or does this only really come into play when you split indi

4
A
5 years ago

Badges

Show all badges
Terms & Conditions