Great!! I thought it would work, I remember somebody from Microsoft doing a
workshop for the Madison County ROE that kept talking about some kind of
server with 64 processors and using a few processors to do this or that. I
didn't really know what she was talking about....I don't think she did
either.
I don't suppose that works with other processes, does it? This is only a
funcationality of SQL Server.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Brian Adams
(MCS)
Sent: Tuesday, August 21, 2001 9:47 AM
To: [EMAIL PROTECTED]
Subject: RE: [Techgeeks] SQL Server
Absolutely. It is actually quite simple to set processor affinity in
SQL Server 2000. Simply right-click on the server you wish to change
from SQL Enterprise Manager, select properties, then select the
"Processor" tab and simply place a checkmark next to each CPU that you
would like to allow SQL to use.
If you change your mind later, it is very easy to modify this setting to
include other processors.
Be sure to leave CPU 0 unchecked and put SQL on CPU 1. Most of the
threads that make up Windows will kick off on CPU 0, generally leaving
CPU 1 a little more open for other tasks.
If performance is an issue at all, I would kick SQL onto the second
processor just to see if it makes a difference. Compared to the $16,000
that corporate America has to pay for a CPU license, you're in a much
better place ;-)
Hope this helps!
Sincerely,
Brian E. Adams, MCSE+I, MCSD, MCDBA, CCNA
Microsoft Corporation
Central Region Financial Services Group - MCS
Pocket PC and Embedded Windows Champ
Voice: 309-287-3094 / E-Mail: [EMAIL PROTECTED]
-----Original Message-----
From: Abe Loveless [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 9:25 AM
To: Techgeeks@Lists. Fayette. K12. Il. Us
Subject: [Techgeeks] SQL Server
This is mostly a question for Brian, but maybe we can all benefit.
I have a Windows2000 Server with 2 processors. I am running (actually,
I
will be running) MS SQL Server 2000. Is it possible to set SQL Server
to
use only one of the processors, and let the other processor run the rest
of
the server? The server isn't going to be doing anything but SQL, but I
think this could save me some money on my license.
To use SQL Server on the web, I have to license the server for unlimited
connections per processor. This cost turns out to be about $2050 per
processor...after Educational Discount of course. Any help to make
things
cheaper is always appreciated.
Thanks,
Abe
Abe Loveless
Network Specialist
Area 5 Learning Technology Center
200 Clay Street Phone: 618-692-6200 ext.4571
Edwardsville, IL 62025 Fax: 618-659-9338
To unsubscribe, send a message to [EMAIL PROTECTED] with
unsubscribe techgeeks
as the BODY of the message. The SUBJECT is ignored.
To unsubscribe, send a message to [EMAIL PROTECTED] with
unsubscribe techgeeks
as the BODY of the message. The SUBJECT is ignored.
To unsubscribe, send a message to [EMAIL PROTECTED] with
unsubscribe techgeeks
as the BODY of the message. The SUBJECT is ignored.
