multi processor server

Can the Standard edition of SS2000 take advantage of multiple processors or
do we need the enterprise edition? Do we need the enterprise edition to take
advantage of memory over 4G?
Thanks,
--
Dan D.Std edition of SQL Server 2000 can use up to 4 processors although not all
commands will use them in parallel. For instance Creating or reindexing an
index will not use multiple processors. But queries can use parallelism when
appropriate. You do need Enterprise Edition to use more than 2GB of memory
in 2000. IN 2005 though Std edition can use up to the OS maximum for memory.
--
Andrew J. Kelly SQL MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:AA36EAB7-E084-4DBB-A9FC-D79204FA5A0D@.microsoft.com...
> Can the Standard edition of SS2000 take advantage of multiple processors
> or
> do we need the enterprise edition? Do we need the enterprise edition to
> take
> advantage of memory over 4G?
> Thanks,
> --
> Dan D.|||We have a box with 8 processors. Will the standard edition of 2005 use the 8
processors?
Thanks Andrew,
--
Dan D.
"Andrew J. Kelly" wrote:
> Std edition of SQL Server 2000 can use up to 4 processors although not all
> commands will use them in parallel. For instance Creating or reindexing an
> index will not use multiple processors. But queries can use parallelism when
> appropriate. You do need Enterprise Edition to use more than 2GB of memory
> in 2000. IN 2005 though Std edition can use up to the OS maximum for memory.
> --
> Andrew J. Kelly SQL MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:AA36EAB7-E084-4DBB-A9FC-D79204FA5A0D@.microsoft.com...
> > Can the Standard edition of SS2000 take advantage of multiple processors
> > or
> > do we need the enterprise edition? Do we need the enterprise edition to
> > take
> > advantage of memory over 4G?
> >
> > Thanks,
> > --
> > Dan D.
>
>|||Not 8 individual processors. It will use 4 dual core or 4 Hyper-Threaded
processors but not 8 physical processors.
--
Andrew J. Kelly SQL MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:8254B71A-D71B-404B-BE48-6521820989C5@.microsoft.com...
> We have a box with 8 processors. Will the standard edition of 2005 use the
> 8
> processors?
> Thanks Andrew,
> --
> Dan D.
>
> "Andrew J. Kelly" wrote:
>> Std edition of SQL Server 2000 can use up to 4 processors although not
>> all
>> commands will use them in parallel. For instance Creating or reindexing
>> an
>> index will not use multiple processors. But queries can use parallelism
>> when
>> appropriate. You do need Enterprise Edition to use more than 2GB of
>> memory
>> in 2000. IN 2005 though Std edition can use up to the OS maximum for
>> memory.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
>> news:AA36EAB7-E084-4DBB-A9FC-D79204FA5A0D@.microsoft.com...
>> > Can the Standard edition of SS2000 take advantage of multiple
>> > processors
>> > or
>> > do we need the enterprise edition? Do we need the enterprise edition to
>> > take
>> > advantage of memory over 4G?
>> >
>> > Thanks,
>> > --
>> > Dan D.
>>|||Thanks.
--
Dan D.
"Andrew J. Kelly" wrote:
> Not 8 individual processors. It will use 4 dual core or 4 Hyper-Threaded
> processors but not 8 physical processors.
> --
> Andrew J. Kelly SQL MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:8254B71A-D71B-404B-BE48-6521820989C5@.microsoft.com...
> > We have a box with 8 processors. Will the standard edition of 2005 use the
> > 8
> > processors?
> >
> > Thanks Andrew,
> > --
> > Dan D.
> >
> >
> > "Andrew J. Kelly" wrote:
> >
> >> Std edition of SQL Server 2000 can use up to 4 processors although not
> >> all
> >> commands will use them in parallel. For instance Creating or reindexing
> >> an
> >> index will not use multiple processors. But queries can use parallelism
> >> when
> >> appropriate. You do need Enterprise Edition to use more than 2GB of
> >> memory
> >> in 2000. IN 2005 though Std edition can use up to the OS maximum for
> >> memory.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> >> news:AA36EAB7-E084-4DBB-A9FC-D79204FA5A0D@.microsoft.com...
> >> > Can the Standard edition of SS2000 take advantage of multiple
> >> > processors
> >> > or
> >> > do we need the enterprise edition? Do we need the enterprise edition to
> >> > take
> >> > advantage of memory over 4G?
> >> >
> >> > Thanks,
> >> > --
> >> > Dan D.
> >>
> >>
> >>
>
>