Recent content by Bertrand

  1. B

    Slow database

    Hello everybody...I got the dbanalysis.txt file from the command "proutil P:\Progress\Wrk\Pillaud\BD\evolubat -C dbanalys -Bp 10 > dbanalysis.txt" I'm gonna upload the file as soon as I post it.
  2. B

    Slow database

  3. B

    Slow database

    So, I understand that this is a unefficient way of oragnizing data. But can it result in poor performances ?
  4. B

    Slow database

    Hello everybody. I haven't forgotten that case. I'm just waiting tonight (my time) to make an db analysis. I will have a 2 hours time frame to do so. hope it will be enough. What does RPB mean for ? (sorry, I'm a system architect, not a experienced DBA).
  5. B

    Slow database

    Last answer for today (except if I'm courageous tonight): the P: drive, even though accessed through a NAS using iSCSI is seen as a local mapping, not a network mapping Thanks for your help. I'm really far far far from expert (of course ;) ...) but I'm starting seeing what can be done for...
  6. B

    Slow database

    OpenEdge Release 10.2B06 as of Mon Mar 19 19:15:43 EDT 2012 Avertissement : Un autre utilisateur utilise cette base de donnÚes en modification. AccÚder Ó la base avec -RO pourrait engender des rÚsultats inattendus. (1531) Area Name: Control Area, Type 6, Block Size 4096, Extents 1, Records/Block...
  7. B

    Slow database

    OpenEdge Release 10.2B06 as of Mon Mar 19 19:15:43 EDT 2012 OpenEdge Database Description Database Name : P:\Progress\Wrk\xxxxx\BD\yyyyyyy Version : 150.0 Block Size : 4096 Largest Cluster : 8 Create Date : Mon May...
  8. B

    Slow database

    Promon Option 5: Enter your selection: 5 ♀Activity - Sampled at 03/17/14 18:25 for 1004:52:27. Event Total Per Sec Event Total Per Sec Commits 79269804 21.9 Undos 171706 0.0 Record Updates 82473315 22.8...
  9. B

    Slow database

    The 2 cents remark does make sense to explain why the installation of the application, which should start some jobs, processes etc. had an impact in a decrease of the backup performance. I fully agree with your performances assertions and conclusions. But, if the customer does require a...
  10. B

    Slow database

    Rob, I'm sorry. When I was talking about times, it was backup times. - new VM (iSCSI disks) + new installation W2008R2 +copy of the production DB => backup time = 15 minutes - new VM (iSCSI disks) + new installation W2008R2 + copy of the production DB + installation of the application => backup...
  11. B

    Slow database

  12. B

    Slow database

  13. B

    Slow database

    Thanks Rob... I did the infrastructure installation and setup and another company (software development) did the installation/configuration of OpenEdge + the installation of the software. Basically, today, the customers are noticing slow accesses, not on a regular basis, and the other criteria...
  14. B

    Slow database

  15. B

    Slow database

    I have a similar problem. VMware 5.1, a application using a Progress DB. The first notice was about backup time: -> backuping 35 Go took 2h30 when the fileserver (VM under VMware + NetApp Filers FAS2020) was using NFS to access the FAS disk -> backuping 35 Go took 52/55 minutes when the file...
Top