SQL Tips by Namwar Rizvi

August 5, 2007

Utilize multiple processors’ power by using just a single SQL Server license

Filed under: Information,Performance,SQL Server 2005 — namwar @ 8:40 PM

Everyone knows multiple processors mean more power to SQL Server but this also means multiple licenses i.e. one for each processor. So is there any way we can reduce cost but not the SQL Server computing power???
Yes, there is a way; buy multi-core processor.
SQL Server is licensed for each socket no matter how many cores do you have. A quad core processor means you can have the power of 4 processors smashed in one socket so you just need 1 license of SQL Server.

Don’t confuse Hyper-threading with Multi-core systems because Hyper-threading is just the virtual core not more than that. Infact a hyper-threaded processor sometime may slowdown your query because of lack of actual parallelism possible.
On the other hand multi-core processors have totally different architecture and will behave like real multiple processors.
So if you are about to suggest multiple processors for the new SQL Server then think again and research on multi-core processors and save your company money.
For the detailed discussion of dual processor and Multi-core architecture, please visit here


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: