A system and method for database management are disclosed. The system comprises a processor configured to monitor performance metrics of a database in real-time based on one or more on-going transactions associated with the at least one database. Based on the performance metrics or historical data, the processor, vi...