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...
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...
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...
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?
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...
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.
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...
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...
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...
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...
Hi Rob,
Yes.
Promon 1 1 shows:
User Control:
Usr Name Type Wait Table Dbkey Trans PID Sem Srv Login Time IPV# Remote Address
19 SYSTEM SQSV -- 0 0 0 15892 0 0 01/19/17 11:26
20 SYSTEM SQSV --...
Hi,
OE10.2B SP07 64bit, Windows Server 2008 64 bit.
I wondered if you could help, i'm racking my brain trying to figure this out.
We have 3 brokers setup on our database, 1 for ABL and 2 for SQL. We have one user (currently) connected via SQL.
How can i tell which broker/server the user is...
Thanks Tom.
Could you elaborate on this please? - "The block size on the VMAX LUN is not the same entity as the filesystem block size." It's something i'm not familiar with.
Maybe i'll not quote that response and go for a slightly more gentle approach to our supplier. :)
Hi all,
Our supplier is upgrading our storage to VMAX LUN's and asked if we would consider formatting the disks to 64k.
We currently have 10.2BSp07 running a 4k database block size on 4k disks on windows server 2008.
I've just read the below:
Optimal NTFS block size for Progress 10.1C...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.