| Author |
multi processor server
|
|
| Dan D. 2006-03-05, 8:24 pm |
| 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.
| |
| Andrew J. Kelly 2006-03-05, 8:24 pm |
| 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@microso
ft.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.
| |
| Dan D. 2006-03-05, 8:24 pm |
| 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@microso
ft.com...
>
>
>
| |
| Andrew J. Kelly 2006-03-05, 8:24 pm |
| 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@microso
ft.com...[color=darkred]
> 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:
>
| |
| Dan D. 2006-03-05, 8:24 pm |
| 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@microso
ft.com...
>
>
>
|
|
|
|