The third Level in our Stairway to Virtualization series is now live at SQL Server Central! In this Level, we will review building the ideal VMware-based virtual machine for your SQL Server workloads. Review and incorporate your own corporate standards and policies into these recommendations, and build the VM that best matches your organization’s needs.
Heraflux has released a free PowerShell-based testing script to help you see how well your storage performs under varying types and intensity of workloads.
Microsoft’s SQLIO disk benchmarking utility had served the SQL Server community extremely well for many years. However, Microsoft has recently released a new storage benchmarking utility, called DiskSpd, as an open-sourced project for the community. This utility provides a more granular storage testing methodology, along with sub-microsecond latency values that are very important with today’s all-flash and hybrid storage devices. DiskSpd is now Heraflux’s preferred method for stress-testing storage devices.
David Klee from Heraflux and Bala Narasimhan from PernixData discuss the tips for DBAs and Infrastructure Admins to maximize the performance of their systems without massive restructuring of their environments.