Help: Processor Configuration

Currently my SQL Server is using 4 processors. Is it wise or not to
reconfigure so my SQL Server will use processor 1,2 and 3 only. And let
the OS use processor 0 for I/O sub system?
Thanks"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:euxYLxbWFHA.3044@.TK2MSFTNGP10.phx.gbl...
>
> Currently my SQL Server is using 4 processors. Is it wise or not to
> reconfigure so my SQL Server will use processor 1,2 and 3 only. And let
> the OS use processor 0 for I/O sub system?
>
No. IO is not processor-intensive, and IO is not performed on a seperate
thread from the thread requesting the IO.
David|||Hi,
No need to assign a seperate CPU for OS, OS will utilize the CPU's
automatically. So if your SQL Server is dedicated then it is always
recommended
to give all the 4 CPUS to SQL Server for optimal performance.
Thanks
Hari
SQL Server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:euxYLxbWFHA.3044@.TK2MSFTNGP10.phx.gbl...
>
> Currently my SQL Server is using 4 processors. Is it wise or not to
> reconfigure so my SQL Server will use processor 1,2 and 3 only. And let
> the OS use processor 0 for I/O sub system?
> Thanks