CPU and I/O affinity config

I have 8 Processors and 12 GB memory box, I want to install two production
SQl Server 2005
instances on this box. Please advise what is the correct seeting to set these
processor affinity and i/0 affinity.
I am planning to assaign 4 CPu for one instace and 3 instances for another
instance.
My confusion is i need to use same CPUs for CPU affinity and i/o affinity or
how to achive this?
4 CPU for one instanec - 0,1,2,3. here confusion i need to check 0,1,2,3 use
CPY affinitymask and 0,1,2,3 to i/o affinity mask or 0,1 for CPU affinity
mask 2,3 for i/o affinity mask.
Please give some advise or related articleas on this how to do configure.
--
SQL serer DBAHi
According to http://msdn2.microsoft.com/en-us/library/ms189629(SQL.90).aspx
"When specifying the affinity I/O mask option, you must use it with the
affinity mask configuration option. Do not enable the same CPU in both the
affinity I/O mask switch and the affinity mask option"
John
"Srikanth" wrote:
> I have 8 Processors and 12 GB memory box, I want to install two production
> SQl Server 2005
> instances on this box. Please advise what is the correct seeting to set these
> processor affinity and i/0 affinity.
> I am planning to assaign 4 CPu for one instace and 3 instances for another
> instance.
> My confusion is i need to use same CPUs for CPU affinity and i/o affinity or
> how to achive this?
> 4 CPU for one instanec - 0,1,2,3. here confusion i need to check 0,1,2,3 use
> CPY affinitymask and 0,1,2,3 to i/o affinity mask or 0,1 for CPU affinity
> mask 2,3 for i/o affinity mask.
> Please give some advise or related articleas on this how to do configure.
>
> --
> SQL serer DBA