Search results

I've just found this which should answer my query; Progress KB - Should the database block size always be 8K? Thanks

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

I've managed to export and import the task and it does seem to be behaving better with a higher priority, although the subsequent rfutil command is called inside the .bat as; %COMSPEC% /C _rfutil.exe %db% -C roll forward -B 5000 -a %ai%.ai%ai-num% and using ProcExp it's showing as the rfutil...

Thanks. It's Windows Server 2008. I'll try the import, export process. Se what that returns. Thanks all.

Hi all, I thought i'd provide some form of update and a little bit more background to this. We use windows task scheduler to perform the roll forward and this is what is causing the headache. If I run the bat file interactively the process runs much faster than it does when run via task...

The web log were there but they've formatted a little weird. I've attached. Ok, some good news then i guess. i'll see what we can do code wise and see if that improves anything. proTop inst installed yet. I've requested it though. Hopefully it will be available soon!

Thanks TheMadDBA. i've attached a full list of checkpoints for 24 hours at 120 second intervals and APW's at 30 second intervals for 24 hours. Note the backup is at 20:30 - 01:12. I have a feeling our F: drive isnt the best storage available. Once i hear back from the 3rd party i can look at...

Hi CJ, Here is the database backup log: [2016/06/07@20:31:37.242+0100] P-15900 T-33712 I BACKUP336: (-----) Login by User1. [2016/06/07@20:31:37.267+0100] P-15900 T-33712 I BACKUP336: (12850) Backup blocks will be written to F:\db\live.bak. [2016/06/07@20:31:37.268+0100] P-15900 T-33712 I...

Thanks for the reply Tom. The slow responses we receive seem to tie in with the checkpoints. Particularly at night and during the morning. The APW might help during the online backup was my thought when write percentages seem to be rather low. The idea behind setting the bi cluster lower was...

Hi All, OE 10.2BSp07 32-Bit on Wndows Server 2008 64-bit. We seem to be having some issues with Checkpointing. The issue is much much worse during online backups but during the day we are experiencing the issues too. I've been looking into this and the issues seem to tie in with checkpoints...

Thanks Cringer. The post was helpful. Although, it raised a few questions; Can i update the _Attributes1 field manually? Where do code page and collation get set? If code page and collation only get set within OE explorer both databases had the same values. Hence why i ask a rather simple...

OE10.2BSP07 Windows 64bit. OK, so by what magic is the CLOB-Type set within the .df file? Here's my .df file ADD FIELD "cField" OF "CTable" AS clob FORMAT "x(8)" INITIAL ? POSITION 3 LOB-AREA "Data Area" LOB-BYTES 104857600 LOB-SIZE 100M CLOB-CODEPAGE "1252" CLOB-COLLATION...

OK, you've convinced me. I'll use ProTop.

Thanks Tom. Mainly the size of the database (1TB+), the growth (0.6G per day) and the activity suggest to me that only one APW is pushing it. Although during normal activity it does seem to perform well. Checkpoints to me seem very good; ♀05/03/16 Checkpoints 13:09:08 Ckpt...

Hi All, On OE10.2BSP07, Windows 64bit. I'm trying to determine if/when APW's are being stretched. Currently we have one running - I know this should be probably be more, I just need to justify it. Currently within promon the 'Writes by APW' sits at a nice 98%, a sample of an hour is the same...

I thought that was the case! To me 61 billion is a lot; our most is 149 billion! And that's on a table with 143,000 records. Yes there are issues. Finding them is what i plan to do next. Ive done an xref on all our code; it's just the small matter of going through it all! I'll look at the...

From the table above IdxItemCode kicked out 61billion reads in a 24 hour period. Now that indexes have been compacted, will the reads lower now they have less blocks to look in. Or will the reads stay the same but the time taken to read the records improve due to the decreased amount of blocks...

Thanks Rob. Sounds good to me. I read a previous post about how the levels make a difference to the BPC, but unless we are about 6 levels 64 BPC should be more than sufficient. I'm the one that checks the .df files before any load to live so the axe would fall with me if anything did appear...

Good point. AI has its struggles as it is. I may start with smaller and medium sized indexes and work my way up!

I left myself open for that one! Large indexes are in there own area, smaller indexes have a few areas too. There is the odd exception where indexes are with tables. I'm aware of this and it will get addressed shortly. In regards to separating indexes, if we have a table that has 4 x 40gb...