With SQL expert:
Joey D’Antoni, Senior Architect and SQL Server MVP
Whether you are running in an on-premises or cloud environment, your virtualized storage may not have the performance needed to support your user base. Don’t be misled, there are options in SQL Server, Windows and your infrastructure beyond upgrading your SAN or hardware to improve your performance.
Improving SQL Server Virtual Machine Storage Performance:
- Understand the two I/O taxes on a SQL system and how they steal performance
- How small, fractured, random I/O characteristics occur and rob performance
- Proper configuration of your VM storage adapters for database workloads
- SQL Server best practices and settings for virtual machines
Learn tips like these from Joey D’Antoni, Senior Architect and SQL Server MVP:
“Don’t over-allocate your CPUs. If your box has too many CPUs that can have performance impact.”
“Don’t under-allocate memory on the VM itself. Don’t over-allocate memory on the host. Make sure you have the right amount of actual memory for your SQL server VM on the physical machine it’s on and you’re not sharing that with other hosts.”
“Probably the most important component of databases is to reduce the amount of I/O they do and to have fast I/O because if you don’t do either of those things your user experience is going to be pretty terrible.”
“Reduce the number of I/Os that you are doing because remember the fastest read from disk you can do is one that you don’t have to do at all. So if you don’t have to do a read, that’s all the better.”
Watch Improving SQL Server Virtual Machine Storage Performance now for many more tips!
Condusiv’s DymaxIO™ for SQL is “set and forget” throughput acceleration software that is the #1 solution for solving slow MS-SQL applications. Learn more about DymaxIO.