Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

desktop engine 2000 versus SQL 2000 server Expand / Collapse
Author
Message
Posted Tuesday, April 28, 2009 11:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 18, 2012 8:41 AM
Points: 27, Visits: 76
We run CAREWare freeware distributed by HRSA under the SQL 2000 Desktop Engine. NOT including additional bells and whistles, is there any computational (speed/ram, etc) advantage to using the desktop engine versus running under a data instance connected to the full-blown SQL-2000 Server ? I am looking at running the provided software only. Any extra query capability, file management, backup, etc, is not to be considered...performance only.

Some here say we will have better response times using the full blown version, others say the desktop engine is better. I would assume that the actual processing of SQL is done by the same engine in both.

Any ideas/comments ?
Post #706110
Posted Tuesday, April 28, 2009 12:09 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 41,530, Visits: 34,446
MSDE (Desktop engine) is a free restricted version of SQL 2000. It has a number of limitations built into it, one of which is a 5 connection limit. As soon as there are more connections that that, it will throttle performance down.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #706149
Posted Tuesday, April 28, 2009 2:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 18, 2012 8:41 AM
Points: 27, Visits: 76
Thank you for the info !!! Thant's exactly what I needed...we have over 10 users and later on...more. We need to upgrade !
Post #706262
Posted Tuesday, April 28, 2009 2:20 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 41,530, Visits: 34,446
I don't know if you can buy SQL 2000 any longer. It's been out of support for about a year now. Is upgrading to SQL 2008 an option?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #706271
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse