SQL Server and Multicore
Because it's designed to take full advantage of multiprocessor SMP systems,
SQL Server can utilize all of the cores in a multicore system; you don't need
to make any system or configuration changes. In addition, Microsoft doesn't
charge licensing premiums for multicore processors. The company charges for
SQL Server (and all other Microsoft products that are licensed by CPU) according
to the number of sockets rather than the number of cores. For example, if you
have a 2-way system that's running single-core processors, you need to purchase
a license for two processors. But if you later upgrade that 2way system to two
dual-core processors, no change in licensing is required because the number
of motherboard sockets doesn't change.
The best thing about hardware competition is the price and performance benefits
it brings to customers. Intel and AMD's multicore duel brings those benefits
in spades by delivering SMP power at single-CPU prices. Table
1 shows a few representative server offerings from HP, Dell, and IBM for
dual-core systems, any of which would work well for running SQL Server.
The Future is Multicore
Intel announced its next line of multicore chips, code-named Penryn, last fall
and expects to make those products available later this year. The Penryn line
of processors will utilize a new 45nm manufacturing technology, enabling Intel
to increase processing speed while simultaneously reducing power requirements
and heat generation. The move to 45nm manufacturing will give Intel a temporary
leg up on AMD in the game of processor leapfrog, but AMD plans to bound back
with its own line of 45nm chips for 2008. Look for Intel's next big move in
late 2008 with its rumored eight-core processor, code-named Dunnington.