Search results

So we have a few things here. Due to various network setups at various geographic sites, our complaints fall into three categories or groups. The sites that are on decent network connections, their complaints have been mostly momentary waits for screens and just general slowness between aspects...

Do you mean at the keyboard/user experience or are you referring to the back end?

Hi again Thankfully, after the changes we made the other night, all performance indicators look much better during work hours. BI buffer busy waits are way down Resource waits and timeouts are way down OM lock/latches are now non-existent, zero across the board Checkpoints are now happening at...

Okay, thanks. I'm just trying to get my head around why we are having so many partial writes on BI. I see 12G worth of physical BI files five are "f" and one is "v", one place tells me the BI is 8166M, proutil says something a little different/but the same. Cluster size is set at 16384 and...

Hi All I'm a bit confused re BI We have a directory which contains our BI files, 6 in total which seem to grow to 2G each. Does each of these files represent one cluster? Why in promon and proutil do I seem to have a disparity with BI size and BI cluster size (see attached)

Sorry, should have been more specific. There was a time when no BIW was running on this system. It is running now?? It will be a point of discussion in the future with vendor because, as I understand it, that process is a manual start.

Yes, re BI, we are only changing cluster size, block size and buffers, we may also start a BIW as well. RE the testing, "oh my side, somebody make him stop". No, this turnkey system has no test system. Although I have their "technical" guy on the hook to make all the DB changes and to be...

Most everything I know and love about BI I found here: http://knowledgebase.progress.com/articles/Article/P54984 see section labeled; Providing More BI Buffers Increasing the BI Cluster Size Increasing the Number of BI Clusters We have reason to believe all these things should happen...

Yes, sorry, shooting from the hip... Oh, I forgot part 2 of your question. I wanted vendor to query the PUB objects table for an appropriate setting, but he chose to do a count of db objects. Again, that value not my call, understanding that it appears he did not use the recommended method of...

Yes, I had read in a Progress doc that the recommendation was BI buffers = AI buffers.

These are the changes we are making tonight at 10PM

This is the best of any 5 minute period I've captured - it is usually much worse: and there are ALWAYS buffer busy waits on the BI

Hi We are observing very high "partial writes" on the BI log. From progress, possibilities include: - An APW attempts to write a DB block whose changes are recorded in a BI buffer that has not been written. Because BI notes must be flushed before the AI note is flushed, the APW writes the...

Okay, thanks. That makes a lot more sense with the qualifier "a big win for well tuned systems". In my case I "feel" like LRU was tuned in an attempt to address some larger issue which, of course, seems a bit like a fool's errand. Now if I can ask one more regarding this issue; if the skip...

Placed in directory d:\cladmin, started command prompt with admin privs, cd'd to d:\cladmin executed pt3inst.bat, received following error: This version of PROGRESS does not allow compiles. (471 R-code file not located for ".\lib\install.p". (473) Press space bar to continue. After hitting...

Ahaha, I agree re "bonehead". How's that saying go; when life hands you lemons, fire the DBA

I guess in my mind I conceptualize this as two lists. But I'm okay conceptualizing this as one long list with two distinct ends. From Progress documentation, in the absence of -lruskips (the default of zero), they state that when a new block gets entered in the pool OR an existing block is...

I notice our server settings appear to be quite a bit different than those suggested in the PP: ♀10/24/14 OpenEdge Release 11 Monitor (R&D) 06:52:25 Server Options 1. Server network message wait time: 2 seconds 2. Delay first prefetch...

So I guess what I am struggling with is that no block in our buffer pool appears to ever make it off the LRU list onto our MRU list, given our current settings: First, our latch timing and activity is disabled which leaves us lacking some data. Spin timeouts is 100000, I believe much too high...