desktop engine 2000 versus SQL 2000 server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » desktop engine 2000 versus SQL 2000 server

desktop engine 2000 versus SQL 2000 server

Rate Topic

Display Mode

Topic Options

Author

Message

chilidogie

Posted Tuesday, April 28, 2009 11:33 AM

SSC 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

GilaMonster

Posted Tuesday, April 28, 2009 12:09 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:31 PM
Points: 37,720, Visits: 29,974

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

chilidogie

Posted Tuesday, April 28, 2009 2:04 PM

SSC 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

GilaMonster

Posted Tuesday, April 28, 2009 2:20 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:31 PM
Points: 37,720, Visits: 29,974

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 »

Permissions