|
Home > Archive > MS SQL Server > November 2005 > MSDE vs. SQL Server 2000 sp4
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
MSDE vs. SQL Server 2000 sp4
|
|
| renhai 2005-11-29, 8:23 pm |
| 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?
| |
| Andrea Montanari 2005-11-30, 7:23 am |
| 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
| |
| benamis 2005-11-30, 11:23 am |
| 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 :)
|
|
|
|
|