MSDE Max # of POS Terminals?

Posted by Rick Brown on January 2, 2006, 11:02 am

Please log in for more thread options

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

Rick Brown
DataBasics

> It's about the size of your database, not the umber of terminals. Also,

> you

> should have a server that can keep up with the database. Plenty of memory

> and fast bus & hardrives. No IDE drives.

> "Kinnard" wrote:

>> 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: kinnard@removebmsar.com

Posted by CaseyHanson on January 2, 2006, 10:31 pm

Please log in for more thread options

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
http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true
.

Casey Hanson
New West Technologies