Wednesday, March 21, 2012

Running SqlAgent on a different processor

I have a machine with dual processor installed. I want sqlagent to be run on
the second processor while my normal queries run on the first processor is it
viable"Genius" <Genius@.discussions.microsoft.com> wrote in message
news:2D2F162B-F706-46BE-85E2-63D3BA9AF516@.microsoft.com...
> I have a machine with dual processor installed. I want sqlagent to be run
on
> the second processor while my normal queries run on the first processor is
it
> viable
>
As far as I know this is not possible... in almost every instance you're
better off letting the server OS manage the use context switching of
multi-processor machines.
Steve|||All the Whitepaper studies I've seen show this to be true: that the OS is
far more capable of handling the scheduling work through the SMP processors
than attempting to manually affinitizing the process yourself.
That being said, yes you can affinitize processes. You can manually set the
process affinity to a currently running executable through task manager. If
you want this to be permanent, you must create a registry key in the
Services Key for that process. There is a tool you can download from
Microsoft that will handle the details for you. Search for Process Affinity
to find it.
Sincerely,
Anthony Thomas
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:O896ydn8EHA.208@.TK2MSFTNGP12.phx.gbl...
"Genius" <Genius@.discussions.microsoft.com> wrote in message
news:2D2F162B-F706-46BE-85E2-63D3BA9AF516@.microsoft.com...
> I have a machine with dual processor installed. I want sqlagent to be run
on
> the second processor while my normal queries run on the first processor is
it
> viable
>
As far as I know this is not possible... in almost every instance you're
better off letting the server OS manage the use context switching of
multi-processor machines.
Steve

No comments:

Post a Comment