Skip to Content
0

Backup has very negative impact on system response time

Jun 12, 2017 at 08:58 AM

64

avatar image

Hello,

we are currently working on an issue on high system repsonse times for users while the full backup of MaxDB is running on Windows. When the backup starts (total runtime about 4 hours for ~ 1TB DB) the system gets very laggy and dialog times in the SAP GUI are going up.

Due to that circumstance the full backup is scheduled once a week plus incremental backups on workdays.

Backup Template looks like this:

Type: Complete Data
Device Type: File
Four Devices
Compression/Overwrite: on

Are there any possibilities to optimize MaxDB full backup so the pressure on the SAP system can be lowered?

Thanks in advance + regards

Daniel

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

2 Answers

James Zhang
Jul 07, 2017 at 02:43 AM
0

Hi Daniel,

What is the warning shown in the maxdb analyzer? You can access the analyzer via db50 or dbacockpit.

Best regards,
James

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi James,

sorry for the delay and thanks for your reply!

Here is a screenshot from a day when the full backup is running:

Best

Daniel

0

Hi Daniel,

The red lines shows file system access is slow, which could be the cause, so I think backup takes most of the io resource, maybe you can involve the hardware vendor in checking whether they have some input.

Best regards,
James

0
avatar image
Former Member Jul 06, 2017 at 01:32 PM
0

We got the same problem. It must be typical for MaxDB with default configuration.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Alexander,

have you found any solution or at least a workaround?

Daniel

0