Recent content by BigSlick

  1. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    Thanks for the info Rob, i'll add that in. How does the Furgal test compare with other tests, for instance doing a prostrct create and a 32GB file is created in 2m 32s. Which equates to 215 MB/s. The disks do seem fast for certain operations, our backup times since moving are 20% faster for...
  2. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    The intial problem we saw on 2016 (which we cannot replicate now -oddly) is that we would turn our systems on and run a process to check the checkpoints and the times would be around 0-2 seconds. We would then run our overnights and checkpoint times would peak at around 30 seconds, then once...
  3. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    Yeah 5TB, We have another database too which is starting to catch up. But this particular database has one table with 5 billion records in it. Were looking at reducing this as its just not cricket. :) The furgal test; i've done a variety of tests on most servers using this and Crystal Disk; the...
  4. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    Now thats what i needed. Cheers Rob. Looks great.
  5. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    Pinshm does wotk in Windows, i had to check using RAMMap and dont understand why the arcticle says that. Both BIW and AIW are running, apologies i should have mentioned this; theyre default to me :) I believe Libor advised the -G and -groupdelay settings. Should i try with defaults?
  6. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    We are talking Windows here, Tom :-D The numbers correlate to the system pausing though in which write activity cannot take place, so surely the lower the numbers the less pausing and the more writing and therefore better performance the system is experiencing. Unless, of course, the sync time...
  7. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    Using RAMMap you can clearly see that it does, in fact do as expected.
  8. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    It does and i think its trying to emphasise large systems and the trade off with having 10%+ in memory. This trade off of scanning a massive -B will increase checkpoint durations, so i believe they are suggesting 90% in order to allow a lower -B therefore reducing scanning times.
  9. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    Hi Rob, Well, based on my tests its benchmark. In regards to Sync Time, yes with directio sync time is 0. But i'd have thought we would see a knock-on effect somewhere else within the process. Unless of course syncing is still happening and freezing occurs, but isnt recorded within OpenEdge...
  10. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    Hi Tom, When doing the initial testing the users were experiencing screen pauses in line with write activity as expected. This was averaging 11.74 seconds without directio. So was quite noticeable. This test replicates one of our overnight jobs and only if it runs late will it normally...
  11. B

    Question Checkpoint Duration Sync Time and Direct I/0 (-directio)

    Hi, The aim of this post is to determine whether -directio is the answer. Are there any downsides to using it? My research indicates an almost 90% improvement. All from Sync Time, which correlates to Progress KB - What value should -B be set to?, although this suggests it will only improve...
  12. B

    Prague

    Hi guys, are the slides from the presentations available anywhere yet? TIA
  13. B

    Question Openedge 10.2b Odbc Driver Compatibility In 11.6

    Hi All, We are planning an upgrade to OpenEdge 11.6.3 shortly and have a lot of ODBC connections currently in use. In order for a smoother upgrade and an easier back out does anyone know of any limitations that the 10.2B ODBC driver has when connecting to OE11? We have done some initial...
  14. B

    Answered Which Broker/server Is A User Using

    Thanks TheMadDBA. Makes so much sense - unlike me.
  15. B

    Answered Which Broker/server Is A User Using

    or port 30050. (2 sql brokers)
Top