HYPER-THREADING configuration hints

Hi
We have a SQL 2000 ENTERPRISE, running on four Hyper-threaded processors, 8
GIG of Memory, Windows SERVER 2003, connected to EMC.
Does anybody have any general rules for configuration for such a server
(it's going to be OLTP) Should we set the affinity to only use the "REAL"
processors. Should we allow all processors to be used for parallelism or
just the "REAL" ones. Anything else we need to consider?
Right now during load testing we are seeing a lot of CXPACKET waits.
Thanks
Paul
Try setting your MAXDOP to use just 4 processors first and see how that
goes.
Andrew J. Kelly SQL MVP
"Paul" <xx@.nospam.com> wrote in message
news:%23AGSkbP0EHA.1264@.TK2MSFTNGP12.phx.gbl...
> Hi
> We have a SQL 2000 ENTERPRISE, running on four Hyper-threaded processors,
> 8
> GIG of Memory, Windows SERVER 2003, connected to EMC.
> Does anybody have any general rules for configuration for such a server
> (it's going to be OLTP) Should we set the affinity to only use the "REAL"
> processors. Should we allow all processors to be used for parallelism or
> just the "REAL" ones. Anything else we need to consider?
> Right now during load testing we are seeing a lot of CXPACKET waits.
> Thanks
> Paul
>
|||I have used the number of physical processors minus 1 as a stating point. In
you case I would start with 3 and work down from there, testing after each
change. Your mileage will vary based on the number of concurrent users and
the types of queries they are executing.
Rob
"Paul" wrote:

> Hi
> We have a SQL 2000 ENTERPRISE, running on four Hyper-threaded processors, 8
> GIG of Memory, Windows SERVER 2003, connected to EMC.
> Does anybody have any general rules for configuration for such a server
> (it's going to be OLTP) Should we set the affinity to only use the "REAL"
> processors. Should we allow all processors to be used for parallelism or
> just the "REAL" ones. Anything else we need to consider?
> Right now during load testing we are seeing a lot of CXPACKET waits.
> Thanks
> Paul
>
>