[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Scalability of SQL92 servers (secondary broker)

  • Thread starter Thread starter gus bjorklund
  • Start date Start date
Status
Not open for further replies.
G

gus bjorklund

Guest
I don't know of any benchmark reports that have investigated the number of threads versus processes for the OpenEdge SQL server. I have not done any. Threads are not some sort of free magic bullet. They require resources like memory, stacks, database connections, and other things. When there are too many threads they become more and more inefficient because they block on locks for memory allocation, scheduler queues and other in-process shared data structures. Also, if a fatal error of some sort occurs, all the threads ion the process will usually die. In the absence of data, I cant give a decent recommendation, but until then, I wouldn't have more than 50 threads per process.=

Continue reading...
 
Status
Not open for further replies.
Back
Top