MSDE Max # of POS Terminals?

Dec 30, 2005 6 Replies

I believe Microsoft recommends running RMS using MSDE on less than 6 POS terminals. Does anyone have experience running RMS with 6 or more terminals and, if so, what is your experience? Thanks for your time and knowledge.



Kinnard L. Kohler Business Machines Systems



6101 South Shackleford Road Little Rock, AR 72204-8606 (T) 501-375-8380 (F) 501-375-0043 Email: snipped-for-privacy@removebmsar.com

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

formatting link

Casey Hanson New West Technologies

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required