Re: Max Specs - SQL 2000 MSDE

Mike,

As indicated on the link that I sent you, MSDE supports a max of two (2)
CPUs -even dual cores.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Mike Snetzko" <MikeSnetzko@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ECE6E8F9-159C-4EDD-9216-E8ABF387E580@xxxxxxxxxxxxxxxx
Thanks Arnie..

So just for clarification -- it will support 4 CPUs? or only 2?

Thanks.
Mike

"Arnie Rowland" wrote:

MSDE will use both CPUs, but the max memory MSDE will use is 2 GB.
Upgrading
to 4GB should work just fine for your needs.

Configuration -Maximum Capacity Specifications
2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp



--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to
the
top yourself.
- H. Norman Schwarzkopf


"Mike Snetzko" <MikeSnetzko@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:28C0F217-131D-4A84-9B6A-7AD5BE0B4EE2@xxxxxxxxxxxxxxxx
Hi All,

I have a MSDE database application that is currently running very
happily
on
Windows 2000, P4 Xeon 2.4GHz, with 1GB of RAM.

We want to upgrade the server due to it being off of lease, and am
looking
at 2 Dual Core Xeon 3.0 w/ 2MB Cache, and 2GB or 4GB of RAM.

This server will also handle all of the day to day file and print and
DC
functions.

Any issues anyone can see running such an MSDE application on the
proposed
HW? What are the MAX hardware that MSDE will function with? Will it
utilize
the 2nd Proc for queries?

Thanks in advance.
Mike





.

Relevant Pages

  • Re: msde 2000
    ... There are a number of third party MSDE tools available, some free, some not. ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.setup)
  • Re: Determine if database is SQL or MSDE, from Enterprise Manager.
    ... Copyright 1988-2003 Microsoft Corporation ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... database listed in Enterprise Manager is SQL or MSDE. ...
    (microsoft.public.sqlserver.msde)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... comments which contradict others' suggestions or material in a ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
Loading