December 11, 2002 at 1:30 pm
Has anyone in this group personally installed SQL 2K Advance server on this?
Does it work well?
How does 2K take advantage of the processors when it can only see one. Is this like taking a dual 400 and now saying it's an 800 when need be. From what I understand two 400mhz boxes is better than one 800 or 1G processor box.
From what I understand MS hasn't blessed this yet. I also hear Big Blue is in love with it.
John Zacharkan
John Zacharkan
December 11, 2002 at 2:06 pm
I have used VMWare in a workstation role running on a linux box with win2k installed on it and sql server I never did any real load testing or things of that nature. I don't know if it would be worth the cost to do a multi-deployment of VMWare server on something as small as an 8 way box for running SQL. If you need more SQL servers per box I would look at virtual servers that SQL provides natively.
As far as multi proc boxes generally more procs equal more load handling due to the ability to spread threads around to diffrent procs and not short the base OS time slices or other SQL threads. At some point a single fast proc is probably going to out perform a dual proc setup if it is fast enough to handle the load.
What I would like to see is the new 3.06 P4's with hyper threading running something like SQL.
December 11, 2002 at 2:43 pm
MS Never blesses anything than can potentially allow the customers to run more than one technical copy of their software at one time.
As for processors and standard motherboard resources all seem jst happy. Where we have been testing has been to find a compatibility issue with an app we wrote so the load isn't that great inside. I will double check speciifcally tomorrow on the processor piece to be sure if it was inside cpu or outside cpu that was what we looked at.
If you think two are better than one, you have been right. But check out Intels site on the newer processor model using hyper-threading. Allows two threads to run concurrent on a single processor. Someone told me they doubled the processor core. With this you only have to license for one but get the effects of two, at least until MS changes that.
December 11, 2002 at 2:49 pm
Not sure about SQL Licensing on this. We are starting to use this in dev servers where we need 3-4 physical servers to test things. Base server only runs VMWare, and 3-4 VMs run on this. Intersting technology. Not sure I like it and not sure about MS's stance.
Steve Jones
December 12, 2002 at 10:42 am
We had been testing a Compaq with Hyperthreading, sorry I never heard the results, and the guy who did the testing is on vacation.
One interesting note it was a 4 way capable with 2 Hyper Xeons, if you added 2 more processors it would disable the Hyperthreading. i.e. that Hardware would not go over "4" processors, logical of physical.
I will try and find the link, but at least for now, MS says a Hyper Chip is ONE processor. Our rep got me the official doc, just don't know if I saved it.
KlK, MCSE
KlK
December 12, 2002 at 5:16 pm
On the VMWare licensing. Currenltly the GSX software only presents one CPU to the VM. We (JD Edwards) are rolling this into production after talking with MS. The host box is a quad, but we only license each VM as a single CPU (using SQL on some of them).
For hyperthreading, I spoke with 3 different marketing and mgmt MS people at PASS. They all said that the licensing is PHYSICAL processer, not logical.
Answered here:
http://www.microsoft.com/sql/howtobuy/faq.asp
Steve Jones
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply