THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rick Heiges

News about SQL Server and the SQL Server Community

Advantage: SQL 2000?

I recently found out from a MSFT rep that the licensing model has changed slightly for 2005 from 2000.  In SQL Server 2000, if you had a box with 8 processors, you could buy llicenses for just 4 procs and adjust the CPU affinity accordingly.  In 2005, if you have a box with 8 procs, you need to buy 8 licenses.  Why?  SQL 2005 still can use affinity to choose CPUs, etc.  BUT... the "other" components (like SSRS) besides the relational engine can not set CPU affinity capable as it was explained to me.  This means that all CPUs will be used and therefore licensed.  Is this an advantage for SQL 2000?  maybe......

BTW, when I use the term processor, think of that as a "Chip".  I am not referencing Dual-Core technology in this post.  But that is an advantage overall with SQL Server.  If you have a Dual-Core chip, that is only 1 license for SQL Server.

Published Wednesday, October 18, 2006 7:26 AM by RickHeiges

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Kevin3NF said:

Interesting...I thought SQL 2000 was for the number of processors in the box, regardless.  Learn something new everyday I guess :)

November 2, 2006 5:59 PM

Leave a Comment


This Blog


Privacy Statement