Archivo por meses: enero 2014

performance progress

incrementar checkpoints dbfinanzas bi log cluster size to 16 MB. proutil dbbasename -C truncate bi bi -bi 16384 set bi log block size to 8 kb. proutil dbbasename-C truncate bi -biblocksize 8 Set -bibufs to 25.  -spin 6000*#procesadores AIW 5 o más

How to tune BI I/O performance

The following is extracted from the v8 documentation. Before-image I/O Before-imaging is always enabled to let PROGRESS recover transactions if the system fails. This mechanism is extremely important for database reliability, but it creates a significant amount of I/O that can affect performance. In addition, before-image I/O is usually the first and most likely cause… Leer más: How to tune BI I/O performance »