Recent content by kdefilip

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...