May 1, 2008 at 1:26 pm
We are currently running two quad core Xeon processors with SQL Server 2005 SP2 Standard 64 bit. I have noticed that one or two processor cores are used by SQL Server more than the others. They are spiking to 100% when the others are basically flat. Is there any way to evenly distribute the load amongst the other processor cores?
May 1, 2008 at 1:56 pm
As long as you have not specified to not use particular processors, MS SQL will use processors as it needs to. You do not have any control over it sending threads to one processor vs. another.
May 3, 2008 at 8:03 am
Im going off memory here but i do recall something that if the license for the SQL is not for say 4 processors and only 2 it will only use 2...but this may be a question for guys at MS.
Some applications code can put in a statement and say only use 1 processor MAXDOP is that the statement....so you might not necessary know this if the code is hard coded.
May 4, 2008 at 10:33 pm
Cores do not count as processors for licensing purposes.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 5, 2008 at 5:43 am
The licenses you purchase does not limit the number of processors the software actually uses. Cores do not count as individual processors.
May 5, 2008 at 7:30 am
Thanks i knew it was something ...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply