Last night my first guest blog pots over at SQLAuthority has gone live! It is the next in the “Notes from the Field” series, and is entitled “SQL SERVER â€“ vCPUs â€“ How Many Are Too Many CPU for SQL Server Virtualization ? â€“ Notes from the Field #003”. I am very proud to be able to contribute to Pinal Dave’s (b | t | f) incredible content on his heavily-trafficked site!
In this post I discuss one of the most critical silent performance killers of an average virtualized environment – CPU overcommitment. In environments designed for consolidation, as so many are, the contention for CPU scheduling can dramatically impact of the database performance. Please head over there and read more!
If you are interested in a deep dive on the topic, you can read more here on a case study about the objective impact of CPU overcommitment on a SQL Server’s performance.