My session today at the SQL PASS Summit 2014 entitled “Right Sizing Your SQL Server Virtual Machine” is going to be broadcast live on the streaming session page called PASStv! It will start broadcasting right at 1:30 PM Pacific time today. View it live here!
Wednesday, November 5, 1:30-2:45PM in Room 6E (Level 300)
Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?
The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.