I support clients who have both VMWARE/HYPER-V/xen virtual machines as well as clients with older "hardware as a service" companies, where a one drive blade is installed form them and then Virtual drives on LUNS back to SANs provide the drive space for the servers aside from the system partitions. My question is, am I wrong in presuming the sector size and the often space wasting way a sector is used is the same in these environments as opposed to physical servers with DAS.
I wonder how much the drive speeds and data access are impacted by thousands of 1k log files from SQL Maintenance drives.
I haven't even started with some of these clients on addressing index fragmentation, etc.
Seems like there are issues in keeping up the speed with virtual SQL servers.
Curt Spanburgh Microsoft Certified Business Solution Specialist. Dynamics CRM MVP Contributing Editor, Windows IT Pro
He that is walking with wise persons will become wise, but he that is having dealings with the stupid ones will fare badly. Proverbs 13:20
Sector size and alignment play a big role in performance. 4K drives are going to shake things up. As it stands, I believe WS2012 Hyper-V is the only hypervisor that's ready: 4K aligned VHDX files.