Sylvie Greverend · Mar 19, 2020

Journal size

Sorry about my newbie question.

How do you decide the size to give to journal1 and journal2?

PS: I am still in version 2016

Thank you


0 250
Discussion (2)2
Log in or sign up to continue

If you can rebalance later, the easiest way is to run the workload and see how much journals are generated.

Otherwise run workload tests in a DEV environment.

The more write-intensive the system is the more journals you need.

Sylvie, you didn't specify the exact version you are using; in v2016.1.1 and later, the limit of 999 journal files per day was removed.

If you are creating a lot of journal activity, and the 999 limit applies to you, you can also increase the size of each journal file so fewer are created each day.  As Eduard posted, testing your workload is the way to determine the journal space you need.