Search results

Here is a better (real) sample of a slow time.

You bet it is.

Yeah, we know 2012 is not certified. [2014/02/03@15:04:38.178-0600] P-9268 T-9264 I BROKER 0: (333) Multi-user session begin. P-9268 T-9264 I BROKER 0: (452) Login by SYSTEM on batch. P-9268 T-9264 I BROKER 0: (5644) Started for 9450 using TCP IPV4 address...

BI cluster size is 524288. AI is not enabled. I can increase the buffer pool. Somebody told me that it wasn't good if it was too high, so we kept it somewhat conservative.

Windows Server 2012. Only one database runs on this server. All AppServers are local. This server has no other workload.

We run separate ports for SQL and ODBC. We are running 64-bit on Windows Server 2012. Are you asking for ubroker.properties?

We run solely on SSDs. I wasn't able to find the -B parameter in my database .pf file. However, using the fathom tool, under the database default configuration, it is set to 500,000 blocks in database buffers. Is that what you were referring to? I almost laughed out loud when I read this...

I guess here is what I am trying to theorize... I'm just a beginner at Progress DBA, so please don't flog me too terribly... It seems like if we get three or four ODBC connections (read uncommitted) or AppServers trying to connect at once, all of the other normal traffic starts to queue up and...

Our server has 80 logical cores. 4 Processors, 10 cores per processor, hyper-threaded. I believe it is an enterprise install. Using it to run our Epicor 9 ERP system.

Question... We run OpenEdge 10.2a. It seems like when we get about 4-5 simultaneous database reads via ODBC (read uncommitted) or AppServers, our system slows way down. Is there a logical maximum amount of simultaneous reads that a Progress Database can handle before it has to start queuing...