MSDE Max # of POS Terminals?

Kinnard,

Its not too much of a problem. We have a couple that run 6 and another that run 7 registers on a dedicated XPP machine with 4 gig of RAM using MSDE. In addition, they have 3 - 4 non register machines for lookups, reports, etc.

Their issues are that they are getting close to the 2 gig database size limitation. We'll be moving them to SQL 2000 Workgroup Edition within a couple of months.

It is a bit like Microsoft saying that RMS runs on 64MB memory. It is true it does but you must be prepared to wait 10 minutes for a screen to update. I do not recommend MSDE for more than 3-4 connections on a network. Also if you have a lot of WO, Layaway, Customers, etc... where the network is used heavily you may find degradation in performance. Past 4 POS go to Full SQL version.

Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk]

What about server OS? Does all of this assume Windows Server 2003 or is XP-Pro acceptable for a dedicated server running MSDE and RMS HQ 1.3?

Thanks,

Dan

It's also about the number of terminals because MSDE has a workload governor that limits the number of simultaneous processes.

Rick Brown DataBasics

"POSable Solutions" wrote in message news: snipped-for-privacy@microsoft.com...

There is a workload governor that will degrade performance if there are more than five concurrent batch workloads. As more workloads are added, the system will continue to slow. For a complete discussion of the workload governor, see

Casey Hanson New West Technologies