MSDE vs. SQL Server 2000 sp4

we have a box loaded SQL Server 2000 sp4 and IIS, user complaining that quer
y
is slow.
recommend change to MSDE.
Is MSDE 2000 using less resource than SQL Server 2000 SP4? and Why?

hi,
renhai  wrote:
> we have a box loaded SQL Server 2000 sp4 and IIS, user complaining
> that query is slow.
> recommend change to MSDE.
> Is MSDE 2000 using less resource than SQL Server 2000 SP4? and Why?

MSDE is SQL Server... they share the same engine core and the same memory
management.. the only difference is MSDE is limited to use 2gb of ram...
that's all... the real problem is that a database server should not be on
the same machine as the application server as they are challeging for
resources on the same box, thus providing poor performance..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.16.0  -  DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Andrea Montanari  wrote:
> hi,
> renhai wrote:
> 
>
>
> MSDE is SQL Server... they share the same engine core and the same memory
> management.. the only difference is MSDE is limited to use 2gb of ram...
> that's all... the real problem is that a database server should not be on
> the same machine as the application server as they are challeging for
> resources on the same box, thus providing poor performance..


remove sp4

sp4 is evil :)