Optimizing data backup schedules

A computer program product for optimizing data backup schedules, the computer program product comprising:

• a computer readable storage medium and program instructions stored on the computer readable storage medium, the program instructions comprising:
• program instructions to identify data representing a first backup schedule for a first backup server;
• program instructions to collect performance metric data that includes performance metric data of one or more computer data storage devices of the first backup server;
• program instructions to identify workload data of the first backup server describing one or more backup logs that are associated with a plurality of jobs that were backed up to the first backup server and executed during one or more respective backup windows;
• and
• program instructions to, in response to determining that a count of backup windows represented by the workload data of the first backup server data meets or exceeds a data collection threshold, execute program instructions to:
• determine a target average I/O rate of the first backup server based, at least in part, on the performance metric data and the workload data of the first backup server;
• determine a maximum average I/O threshold of the first backup server based on the target average I/O rate of the first backup server;
• in response to determining that multiple backup servers exists, receive from a second backup server (i) performance metric data of the second backup server that includes performance metric data of one or more computer data storage devices of the second backup server and (ii) workload data of the second backup server describing one or more backup logs that are associated with a plurality of jobs that were backed up to the second backup server and executed during one or more respective backup windows of the second backup server;
• determine a target average I/O rate of the second backup server based, at least in part, on the performance metric data and the workload data of the second backup server;
• determine a minimum average I/O threshold of the second backup server based on the determined target average I/O rate of the second backup server;
• identify a time at which an average I/O rate of the second backup server deceeded the minimum average I/O threshold of the second backup server while a second job was executing on the second backup server in response to determining that an average I/O rate of the first backup server exceeded the maximum average I/O threshold of the first backup server while a first job was executing on the first backup server;
• generate an updated first backup schedule for the first backup server such that a pending job present on the first backup schedule is omitted from the updated first backup schedule;
• and
• generate an updated second backup schedule for the second backup server such that the pending job omitted from the updated first backup schedule for the first backup servers is present on the updated second backup schedule for the second backup server, thereby offloading the pending job from the first backup server to the second back server.

A computer system for optimizing data backup schedules, the computer system comprising:

• one or more computer processors;
• one or more computer readable storage media;
• program instructions stored on the one or more computer readable storage media for execution by at least one of the one or more processors, the program instructions comprising:
• program instructions to identify data representing a first backup schedule for a first backup server;
• program instructions to collect performance metric data that includes performance metric data of one or more computer data storage devices of the first backup server;
• program instructions to identify workload data of the first backup server describing one or more backup logs that are associated with a plurality of jobs that were backed up to the first backup server and executed during one or more respective backup windows;
• and
• program instructions to, in response to determining that a count of backup windows represented by the workload data of the first backup server data meets or exceeds a data collection threshold, execute program instructions to:
• determine a target average I/O rate of the first backup server based, at least in part, on the performance metric data and the workload data of the first backup server;
• determine a maximum average I/O threshold of the first backup server based on the target average I/O rate of the first backup server;
• in response to determining that multiple backup servers exists, receive from a second backup server (i) performance metric data of the second backup server that includes performance metric data of one or more computer data storage devices of the second backup server and (ii) workload data of the second backup server describing one or more backup logs that are associated with a plurality of jobs that were backed up to the second backup server and executed during one or more respective backup windows of the second backup server;
• determine a target average I/O rate of the second backup server based, at least in part, on the performance metric data and the workload data of the second backup server;
• determine a minimum average I/O threshold of the second backup server based on the determined target average I/O rate of the second backup server;
• identify a time at which an average I/O rate of the second backup server deceeded the minimum average I/O threshold of the second backup server while a second job was executing on the second backup server in response to determining that an average I/O rate of the first backup server exceeded the maximum average I/O threshold of the first backup server while a first job was executing on the first backup server;
• generate an updated first backup schedule for the first backup server such that a pending job present on the first backup schedule is omitted from the updated first backup schedule;
• and
• generate an updated second backup schedule for the second backup server such that the pending job omitted from the updated first backup schedule for the first backup servers is present on the updated second backup schedule for the second backup server, thereby offloading the pending job from the first backup server to the second back server.