Search results

Yep, I use the VSTs daily to keep an eye on BI HWM and some other things, and I've been delving into PROMON R&D. The performance improvement seems very likely to be attributable to the additional APW -- transaction volume should not have fallen off significantly in the five minutes between...

Started another APW, now database is perfectly fast again. Coincidence? Or was our poor solitary APW terribly overburdened? Hmmm. BTW, to check performance I wrote very basic queries (a for each with no where clause, inside a repeat loop) and just counted the number of records it was able to...

Block size is 1024. Database is a little slow now, not as good as in Test but not nearly as slow as yesterday. I'm thinking we need to start up another APW or two, the Database ADmin Guide says nonzero flushes is bad. 10/04/11 Activity: Page Writers 08:26:30 10/03/11 12:21 to...

Well, the Progress version I have for Windows is 9.1, and it always installed fine on XP, but no joy on Win7 even running it with XP compatibility as Admin (it always claims a file is locked, is_del iirc). Alas, MS tells me I am not eligible for the full XP VM on my home machine, so maybe I'll...

Well, we also ran into -n, so we bit the bullet and took a brief outage to restart, doubling our -B in the slow db (along with doubling -n in both). The slowness problem is gone... at least for now. I suspect we ran below some critical ratio of -B to users, in which the DB was spending most of...

Aha, buffer hits are 0%. The Progress database admin guide tells me this is very bad, as they should exceed 95%. Activity - Sampled at 10/03/11 11:54 for 179:42:22. Event Total Per Sec Event Total Per Sec Commits 1186634 1.8...

Hello, we are running QAD 8.6e on Progress 8.3C, sitting on HP-UX. We have two databases, mfgpro85e (which is fine) and addmfgpro (which suddenly starting being slow today; was fine Fri and Sat). Users always connect to both db when entering app. Queries against the slow db are running about...