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.

Ver todos los episodios