Processor Affinity

[gbaughma]

I know that in the Task Manager, I can set Processor Affinity.

Now, this seems like a cool idea... so let me bounce a scenario off of you.

I have a web server with SQLExpress. Now, SQLExpress will only use one processor. I have a quad-core system.

Here are my questions:

1) If I give exclusive affinity to the SQL Server process (say, processor 4), and turn OFF that affinity with all the other processes, will that make my SQL queries run faster?

2) If so, is there a way to set the processor affinity as a default for the services?

3) Would the best scenario be to set 1 processor for SQL, 1 processor for IIS, and the other 2 for the rest of the system? And, if so, see question #2 again.

Thanks in advance!



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[itsp1965]

Don't know about SQL Express but for SQL Server in general this would be set from within SQL Server

http://msdn.microsoft.com/en-us/library/ms187104.aspx

 

[gbaughma]

It looks like what I'm looking for is WSRM (Windows System Resource Manager).

Setting the processor affinity in SQL would be fine, but that doesn't keep OTHER Processes from using that processor.



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[acl03]

Greg - I'm interested to hear how this works for you. We have some older 4-cpu oracle servers that will potentially gain performance from something like this. Interesting idea...

Thanks,
Andrew

Hard work often pays off over time, but procrastination pays off right now!