Tuesday, March 27, 2012

General Beginner Question

Hello, we are interested in purchasing MS SQL Workgroup for our company.

I have two simple questions though. We are going to purchase a 1U rackmount server which has 2 Dual Core Intel Xeon 5050 processors. So the total amount of cores is 4.

I noticed in the spec sheet for Workgroup the max amount of processors is 2. Does our server fall into that category since it has two processors, but each processor has two cores?

Also licensing if I do per processor, do I need two licenses or 4 licenses?

Also, I noticed the max amount of ram for workgroup is 3Gigs. Our rackmount server is going to have 4gigs of ram. Is this a problem? I assume it is fine, just that it can only allocate up to 3gigs of ram. Or, will it not install if you have more than 3gigs of ram in the server?

Thank you much!

One multicore (or hyperthreaded) processor is considered one processor for SQL Server License, see

http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc
Microsoft has been driving thought leadership in this area by charging the same amount per processor, regardless of how many cores are in the processor.

I believe you are OK with regards to memory - the SQL Server will use just 3Gb of course.

P.S. This forum is specific to SQL Integration Service, licensing questions are better for other forums, e.g.
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1

No comments:

Post a Comment