Monitoring query processing trends in a database server to identify periods of anticipated high demand

A computing system having a memory having computer readable instructions and one or more processors for executing the computer readable instructions, the computer readable instructions controlling the one or more processors to perform operations comprising:

• receiving, by a database server, a plurality of queries, each of the plurality of queries being received from one of a plurality of clients;
• providing, by the database server, a response to each of the plurality of queries to a corresponding one of the plurality of clients;
• receiving, by the database server from each of the plurality of clients, resource utilization information associated with processing the response;
• identifying, by the database server, one or more of the plurality of queries as periodically repeated queries;
• identifying, by the database server, a trend of the resource utilization information for each of the plurality of clients;
• determining, by the database server, a period of anticipated high demand on the database server based on the periodically repeated queries and the trend of the resource utilization information for each of the plurality of clients;
• and
• broadcasting, by the database server to each of the plurality of clients, an indication of the period of anticipated high demand on the database server.

A computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to perform operations comprising:

• receiving, by a database server, a plurality of queries, each of the plurality of queries being received from one of a plurality of clients;
• providing, by the database server, a response to each of the plurality of queries to a corresponding one of the plurality of clients;
• receiving, by the database server from each of the plurality of clients, resource utilization information associated with processing the response;
• identifying, by the database server, one or more of the plurality of queries as periodically repeated queries;
• identifying, by the database server, a trend of the resource utilization information for each of the plurality of clients;
• determining, by the database server, a period of anticipated high demand on the database server based on the periodically repeated queries and the trend of the resource utilization information for each of the plurality of clients;
• and
• broadcasting, by the database server to each of the plurality of clients, an indication of the period of anticipated high demand on the database server.