Hi Folks:

How do you script-o-matically set processor affinity on SQL after a
cluster failure?

The purpose is that I'll be failing to a machine with a different
amount of CPU's (4 instead of 8). I want to control what SQL
instances take what amounts of processor.

Is this even possible?

Thanks!

Not that this will help any, but Datacenter allows for this from the Process
Control program

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"The Researcher" <the_re_searcher (AT) hotmail (DOT) com> wrote

.... then I wonder if you can do it in WSRM in Win2k3 that allows you to set
percentages etc on processors - it seems to be derived from the Process
Control Tool in Datacenter ?

Andy.
"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:eHgTAWrjEHA.1656 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

Excellent idea Andy! WSRM is not do processors affinity though. It does do
these things:

Set CPU and memory allocation policies on applications. This includes
selecting processes to be managed, and setting resource usage targets or
limits.

• Manage CPU utilization (percent CPU in use).

• Limit the process working set size (physical resident pages in use).

• Manage committed memory (pagefile usage).

• Apply policies to users or groups on a Terminal Services application
server.

• Apply policies on a date/time schedule.

• Generate, store, view, and export resource utilization accounting
records for management, service level agreement (SLA) tracking, and
charge-back purposes.


see
http://www.microsoft.com/windowsserv...fastfacts.mspx
for more on WSRM.

Its a great package and free for EE and DC editions.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Andy Ball" <andy.ball (AT) remove4spam_greenfell (DOT) com> wrote

Dang English language and spell chuckers! WSRM is not do processors affinity
though - Should be WSRM does not do processors affinity.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:uunBBKJkEHA.3712 (AT) TK2MSFTNGP15 (DOT) phx.gbl...

"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote

ehr, I just checked with the WSRM site and found the following snippet:

• It is not recommended that you use WSRM CPU affinity for SQL Server 2000.

That being said, it doesn't appear as though that's going to work.

Any other suggestions?

Thx