A
Adriano Correa
Guest
grupoci, some sugestions: - I think the -spin parameter is too big. Try to start it with 10000 at most. This parameter may cause de 100% cpu using if it is set to a number bigger then processor capacity. - Is your Progress 32 bits? If so, you may get some issues with the value passed to -B. Try to reduce it to 100000 and monitor with promon to adjust a better value if needed. - The writes by apw are 100% is good. It means that APW is working. You can also check if there is any buffers flushed at checkpoint or how many checkpoint the database is doing per hour. If it is to many, maybe the database is freezing during this process. Also, it seems the server is a virtual machine. Consider to check for performance issues on the main server. Adriano.
Continue reading...
Continue reading...