Search results

  1. P

    Adjust startup parameters using promon or _DbParams VST

    Thanks - restart it is then. Will investigate 11.7
  2. P

    Adjust startup parameters using promon or _DbParams VST

    Ran into a pickle - added - SQLWidthUpdate ON in on a 11.6 database and having some performance issues. Reading that it should be possible to update the parameter with the database online: Progress Documentation using either promon or _DbParams VST. I'm not seeing option 16 - adjust startup...
  3. P

    OE and SQL tuning parameters (-omsize in particular)

    BINGO! ----- Locks ----- ------ Busy ------ Naps ---------- Spins ----------- ----- Nap Max ----- Owner Total /Sec /Sec Pct /Sec /Sec /Lock /Busy Total HWM 04/13/18 20:00:02 OM --...
  4. P

    OE and SQL tuning parameters (-omsize in particular)

    That makes me feel better. I had a hunch, just waiting for the right opportunity to restart.....
  5. P

    OE and SQL tuning parameters (-omsize in particular)

    Yep fewer than 3072: select count(*) from _storageobject 2,623 However, R&D 1|13 Primary object cache (-omsize): Total: 1024 Used: 1024 Pinned: 0 Secondary object cache (-omsize): Total: 3072 Used: 1051 Pinned: 0 I didn't restart, just upped the size online, but omsize startup parameter...
  6. P

    OE and SQL tuning parameters (-omsize in particular)

    Ok - here are the results. Not much of a difference. But I learned a lot in the process and will continue the tuning quest one step at a time.
  7. P

    OE and SQL tuning parameters (-omsize in particular)

    Wheeew - Thanks! I would hate to find that out the hard way.
  8. P

    OE and SQL tuning parameters (-omsize in particular)

    Thanks again guys! I'm just holding off so I can gather more stats. (Didn't know about the hidden menu last week so I had to revise my collection script). I should have 24 hours worth by 12pm today. So I will make the change then. And go from there.
  9. P

    Answered Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO!

    Continuing this thread in OE and SQL tuning parameters (-omsize in particular)
  10. P

    OE and SQL tuning parameters (-omsize in particular)

    This is a continuation of Answered - Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO! that took a new direction. Current omsize is 1024, database objects are 2623. Below are samples from protop and promon for approximately the same 60s interval. Protop...
  11. P

    Answered Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO!

    Will have to get back on this - will probably need to run for at least a few hours with normal load Deng - I was thinking omsize was the magic bullet :-). Will check protop also next week for sure
  12. P

    Answered Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO!

    I agree - my original question has been answered. I wish there was a way to split the thread and create a new one from below the 1st 3rd of the original posts.
  13. P

    Promon report

    Thanks again Rob! I'm running it on Linux.
  14. P

    Answered Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO!

    Been gathering stats from promon r&d activity since yesterday and was about up the omsize. But it doesn't seem like there's a need, or?: Been running gus's test script from 11.3.2: default -omsize & high number of MTL_OM latches - Forum - OpenEdge RDBMS - Progress Community and I don't see any...
  15. P

    Promon report

    Hello, I'm on OE 11.6 / RHEL 5.11 so it might be different but I'm Just curious of the command line arguments you are using for promon in the original post. I haven't been able to find any documentation on promon's command line arguments. Looking at promon, it passes the argumenst to _mprshut...
  16. P

    Answered Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO!

    Thanks again! Will gather some more stats, increase omsize, get stats again and compare. And go from there. We are currently on a SAN, so we can move disks between different types of storage while online. So moving the AI disk will be the next easy step. Ai and database files are backed up to...
  17. P

    Answered Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO!

    Thanks everybody for the input. It's Greatly appreciated! This is a 3rd party system from an outside vendor. So most things are out of my control and I'm not comfortable changing the database configuration too much. I'm a "Jack of all trades", that sometimes put on the junior dba hat and know...
  18. P

    Answered Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO!

    Yes, they are separate: 4GL: -n 1000 -L 1000000 -bibufs 40 -aibufs 60 -B 1750000 -bithold 19999 -bistall -ServerType 4GL -Mi 1 -Ma 4 -Mn 251 -Mpb 218 -maxport 32000 -DBService replserv -pica 8192 SQL: -m3 -Mi 1 -Ma 4 -Mpb 31 -N tcp -S 8001 -ServerType SQL
  19. P

    Answered Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO!

    Thanks! You're right - and I'm not sure :-) if I used ALL - will have to try again. I'm working on a real problem - the query speed is passable now. But I'd like to get it as fast as possible.
  20. P

    Answered Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO!

    I did the whole shebang - UPDATE TABLE STATISTICS AND INDEX STATISTICS AND COLUMN STATISTICS on a couple of tables. The queries are not horrible, just not as snappy as the ABL queries in our ERP. The ERP returns the result asap, and my SQL query takes 2-3s. But I'm not really sure how our ERP...
Top