Skip to Content
-1

Best practice - Log Segment Volume / Log File Size

Feb 16 at 02:59 PM

35

avatar image

Hi,

Searching through SNC, notes, help., guides and google, I didn't find anything about the log segment volume size, with that I can handle the log backup a bit better.

At the moment, there are for one HANA DB (tenant) 44 log files with a size of 1GB each. So if the log is full, it will be dumped, or after 6 hours, DEV/QAS system. During some test, the log were filled up very quick and I just see many of HDB log dumps.

Questions:

- What is the best size for the log files, or how to determine which size would be the best?

- If I resize the logs (log_segment_size_mb), how can i reconfigure the amount of log files? Maybe 15-20 instead of 44.

Thanks and best regards,

Tobias

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers