MSDE Opinions

My software currently runs on Access 2000 Engine. The database is 600 MB and
I can have up to 10 users (6 constantly). I currently run a terminal server
to share out access database. it is Dual XEON 2.8 Ghz with 4 GB RAM.
Is MSDE an option for my setup?
Would I need a second Database server?
Do I need to go all the way up to SQL 2000?
Our software company tells me that MSDE only can handle 10 connections. I
have read that that is not true. Are they basically trying to sell me full
blown SQL for nothing?
Opions greatly appreciated.
Chris
"Chris Blackwelder" <Chris Blackwelder@.discussions.microsoft.com> wrote in
message news:A1F1F198-3357-4657-A0F4-0F2EA7F2F84D@.microsoft.com...
| My software currently runs on Access 2000 Engine. The database is 600 MB and
| I can have up to 10 users (6 constantly). I currently run a terminal server
| to share out access database. it is Dual XEON 2.8 Ghz with 4 GB RAM.
|
| Is MSDE an option for my setup?
Yes.
| Would I need a second Database server?
No.
| Do I need to go all the way up to SQL 2000?
No.
|
| Our software company tells me that MSDE only can handle 10 connections.
Where did they get 10 from? That is a toatly made up number. 5 and 8 are at
least in the docs, but you can exceed them. I have tested heavy loads up to 26
and then my P2-333 server couldn't cope.
I
| have read that that is not true. Are they basically trying to sell me full
| blown SQL for nothing?
Yes, but don't be mad at them. My guess is they don't know better unless they
have load tested it themselvs. MS dosn't allow anyone to publish benchmarks and
there is no reason for MS to advertise them.
|
| Opions greatly appreciated.
I belive MSDE can handle just as much as Enterprise or any other flavor of SQL,
unless you need more than 2Gig of data or 4 CPUs. Here is my tests
http://fox.wikis.com/wc.dll?Wiki~MSD...ks~SoftwareEng
Carl K
sql