Differences between Desktop and Server Edition

H
I have a query concerning SQL server 7. We currently have an NT server 4.0 using SQL server, but however recentl
we have been getting alot freezes from branches. I have noticed that the installation on that server is desktop editon. I am not sure if this the likey reason
What are the differences between desktop and server edition
Should'v the server be installed as SQL server - server edition
Is there any optimising we can there
ThanksThe desktop edition is required for non-server OS's (like NT workstation, or
windows xp).
The functionality is the same, but there is a limit on the number of threads
( maybe 10 I think). When there are more connections than worker threads,
then multiple connections share the same thread and response time
increases... This prevents users from putting Desktop Edition into
production when the full server should be used.
The desktop edition has lower cost than servers, but is intended ONLY for
small small number of users...To increase throughput , you buy and install
the Server Edition.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rakesh" <anonymous@.discussions.microsoft.com> wrote in message
news:59E83439-70FE-4C64-B2C6-164E9B6A39D6@.microsoft.com...
> Hi
> I have a query concerning SQL server 7. We currently have an NT server
4.0 using SQL server, but however recently
> we have been getting alot freezes from branches. I have noticed that the
installation on that server is desktop editon. I am not sure if this the
likey reason.
> What are the differences between desktop and server edition?
> Should'v the server be installed as SQL server - server edition?
> Is there any optimising we can there?
> Thanks|||Do you reckon that SQL server - server edition be installed
Would we have to uninstall the SQL sever deskop edition and install SQL - server edition
How does SQL server optimise its memory management system
Thanks