Licensing sql2k ent
-
I'd be grateful if someone could confirm that with a 8 way zeon 4 box with sql server ent would see 16 procs ( 8 real + 8 logical ) and would use them - thanks
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
Please anyone correct me if I am wrong.
I assume that you are using HypherThread since you are talking about logical CPU. Then, first, I'd like to know what is the O/S that you are using. This is from MSFT white paper about O/S.
2-way
4-way
8-way
Windows Server Product
Physical
Logical
Physical
Logical
Physical
Logical
Windows 2000 Server
2
4
4
4
n/a
n/a
Windows 2000 Advanced Server
2
4
4
8
8
8
Windows 2000 Datacenter Server
n/a
n/a
4
8
8
16
Windows .NET Web Server
2
4
2
4
n/a
n/a
Windows .NET Standard Server
2
4
2
4
n/a
n/a
Windows .NET Enterprise Server
2
4
4
8
8
16
Windows .NET Datacenter Server
n/a
n/a
4
8
8
16
16-way
24-way
32-way
Physical
Logical
Physical
Logical
Physical
Logical
Windows 2000 Server
n/a
n/a
n/a
n/a
n/a
n/a
Windows 2000 Advanced Server
n/a
n/a
n/a
n/a
n/a
n/a
Windows 2000 Datacenter Server
16
32
24
24†
32
32†
Windows .NET Web Server
n/a
n/a
n/a
n/a
n/a
n/a
Windows .NET Standard Server
n/a
n/a
n/a
n/a
n/a
n/a
Windows .NET Enterprise Server
n/a
n/a
n/a
n/a
n/a
n/a
Windows .NET Datacenter Server
16
32
24
24†
32
32†
And then check it out this link.
http://www.microsoft.com/sql/evaluation/overview/default.asp
So if you have SQL Ent with Windows 2000 Advance Server or up, SQL server, that you will get the all 8 + 8 CPUs.
One thing that you need to know is that if you are using Windows 2000, you need to pay for 16 processors license and put 16 when you install sql but if you are using Windows 2003, just put 8 processors and purchase 8 CPU licenses only. O/S will know and read the Logical processors.
Any comments are welcome.
-
sorry, yup using 2k adv server, but thinking about 2003 ent server.
Just trying to clear in my head if a server with 8 zeon 4's ( with HT ) would be seen by sql server as having 16 procs and sql server would use 16 on both platforms.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
SQL Server w/Wwinds2K Advanced server only see's 8 physical or 8 logical processors (the chart reflects this as well)
-
The bigger issue here is if you're using HT, what these extra processors are, is in fact ,unused cycles from the physical processors. If you are using win2k there is a chance of that code executing in these "processors" to be caught in a continus loop that results in an app hang. I just found this out at a MS seminar.If you can, upgrade to Win2k3 it eliminates this problem.
-
Yes I'm aware of possible issues with HT, but to date ( nearly 2 years using zeon 4's ) I've not encountered any problems.
Yes I agree w2003 is a better way to go, especially as I can use more memory - however - very controlled environments so i have to tread carefully < grin >
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
Funny how a simple question gets to be so complicated. Yes, SQL Server will see 8 physical processors as 16. Configure as 16 to allow all physical & logical processors to be used.
I depart from iLoveSQL's comments regarding "... you need to pay for 16 processors license..." per Microsoft's policy on hyperthreading CPU's: http://www.microsoft.com/sql/howtobuy/hyperthreading.asp which states:
On a system with Intel HTT enabled, Microsoft requires only one license for each physical processor. Therefore, customers only need to acquire one processor license for each physical processor even though the software may count one physical processor as two logical processors.
Respectfully,
David
-
I must confused w/ others factors or something. Based on that article, it didn't mention about win2k or win2k3 different license issue. So David is right. Sorry about confusing.
I just went over the whitepaper "Microsoft Windows-Based Servers and Intel Hyper-Threading Technology http://www.microsoft.com/windows2000/server/evaluation/performance/reports/hyperthread.asp"
again and I must confused with windows license with 4 CPU. Since "W2K Server" Edition has 4-CPU limit, even if you have HT, you can't use all 8 logical processors and even 4-CPU usages is not fully untilized. So you have to get "Win2K Advance Server (8CPU limit)" and your orignal case, you have 16 Logical processors, you are in Win2K shop but thinking about Win2K3 shop, you better go to Win2K3 because, if you don't have Datacenter version, you won't be able to take advantage of HT.
So, that's why first time we decide to go for HT, I heard that I have to pay more expensive license it wasn't from SQL but windows license.
Please read again the link and if that is not true, let us know. License is my weakest part
-
It was such a simple question
The upshot was as I suspected that on w2k ( adv server ) the 8 cpu limit would not allow me to take advantage of the HT technology on a box with 8 physical processors.
The move to w2003 is one I can only influence not make - but it will be soon!
thanks very much for the clarification chaps!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
It was such a simple question
The upshot was as I suspected that on w2k ( adv server ) the 8 cpu limit would not allow me to take advantage of the HT technology on a box with 8 physical processors.
The move to w2003 is one I can only influence not make - but it will be soon!
thanks very much for the clarification chaps!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply