1. A method for archiving of monitoring data by enabling real-time analysis within a live database, the method comprising: receiving, by a processor, a set of parameters, wherein the set of parameters is selected based on monitoring data of a system application; determining, by a processor, a historical schema of monitoring data, which includes a rolling retention period for the historical schema, and a rolling retention period for a current schema of monitoring data, based on the set of parameters; performing, by a processor, an impact analysis of the historical schema of monitoring data and the rolling retention period of the current schema of monitoring data; and in response to receiving acceptance of the impact analysis, generating, by a processor, the historical schema, which is applied to monitoring data, populated by copying monitoring data from the current schema to the historical schema, within the live database.