EPISODE · Sep 12, 2012 · 33 MIN
Glenn Berry Saves Money on SQL Server Hardware!
from RunAs Radio · host Richard Campbell
Richard chats with Glenn Berry about SQL Server hardware. Microsoft changed the licensing of SQL Server in 2012 to per-core rather than per-socket, suddenly making SQL Server much more expensive if you've gone to lots of cores. Glenn talks about how to assess your workload to know if you need as many cores as you currently have, why you shouldn't upgrade in place and use old hardware for SQL Server 2012 and the differences between Intel and AMD CPUs in this new world. Lots of geeky hardware speak, but if you do it right, you can make your SQL hardware almost free! Glenn mentions a couple of important web sites related to SQL performance in relation to hardware, including the TPC-E stats and Geekbench to understand how your hardware performs.
What this episode covers
Richard chats with Glenn Berry about SQL Server hardware. Microsoft changed the licensing of SQL Server in 2012 to per-core rather than per-socket, suddenly making SQL Server much more expensive if you've gone to lots of cores. Glenn talks about how to assess your workload to know if you need as many cores as you currently have, why you shouldn't upgrade in place and use old hardware for SQL Server 2012 and the differences between Intel and AMD CPUs in this new world. Lots of geeky hardware speak, but if you do it right, you can make your SQL hardware almost free! Glenn mentions a couple of important web sites related to SQL performance in relation to hardware, including the TPC-E stats and Geekbench to understand how your hardware performs.
NOW PLAYING
Glenn Berry Saves Money on SQL Server Hardware!
No transcript for this episode yet