Archives: May 2015
A few weeks ago, while at the incredible SQL Saturday Madison, I had a great discussion with a few of the other speakers about SQL Server VM-level memory counters and their (lack of) validity on the actual memory usage properties of the SQL Server engine. A while back, I… Read more
The third Level in my 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… Read more
Yesterday the next installment of the Stairway to Virtualization series went live on SQL Server Central! This level focuses on the core “why” questions when it comes to building the ideal SQL Server virtual machine. It focuses on all of the core “why” questions, such as how to configure… Read more
Recently, I was able to help SimpliVity work to develop a reference architecture document for running resource-intensive SQL Server virtual machines on the SimpliVity OmniCube platform. We went through a lot of different OLTP workload types and have put together a number of best practices for virtualized SQL Server on… Read more
A few weeks ago Bala Narasimhan from PernixData and I recorded a short conversation where we discussed the tips and tricks that both DBAs and Infrastructure Administrators need to maximize the performance of their systems without significant re-architecting of their environments. Check it out!
Bala Narasimhan, Vice President of Products from PernixData, and I recently sat down and discussed the convergence of infrastructure, SQL Server, virtualization, and storage systems. We chatted about some of the ongoing challenges of high performance virtualized SQL Servers and the impact they can have on the rest… Read more
My recent post on using the new DiskSpd utility to help you benchmark your storage is a great primer on how to use DiskSpd. But… what if you want to run multiple tests? For example, what if you want to run both read and write tests with a varying degree… Read more