Microsoft SQL Server Desktop Engine - Max Specs

Author

Max Specs - SQL 2000 MSDE

Mike Snetzko

2006-12-11, 7:16 pm

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

Arnie Rowland

2006-12-11, 7:16 pm

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/d..._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@discussi
ons.microsoft.com> wrote in message
news:28C0F217-131D-4A84-9B6A- 7AD5BE0B4EE2@microso
ft.com...
> 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

Mike Snetzko

2006-12-11, 7:16 pm

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/d..._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@discussi
ons.microsoft.com> wrote in message
> news:28C0F217-131D-4A84-9B6A- 7AD5BE0B4EE2@microso
ft.com...
>
>
>

Arnie Rowland

2006-12-11, 7:16 pm

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@discussi
ons.microsoft.com> wrote in message
news:ECE6E8F9-159C-4EDD-9216- E8ABF387E580@microso
ft.com...[color=darkred]
> Thanks Arnie..
>
> So just for clarification -- it will support 4 CPUs? or only 2?
>
> Thanks.
> Mike
>
> "Arnie Rowland" wrote:
>

Sponsored Links