Managing databases in data storage systems

A system for use in managing data-storage for a database application executing on a server coupled to the system based on application awareness, the system comprising:

• a plurality of nodes;
• a memory;
• and
• at least one hardware device, coupled to the memory, operative to:
• store application settings corresponding to the database application;
• receive an instruction to provision storage for the database application;
• in response to receiving the instruction, access the application settings to automatically provision storage for the database application that includes distributing database tables across the plurality of nodes;
• capture I/O activity information in connection with the database application;
• perform an operation to detect an imbalance in connection with the database tables, wherein the performed operation detects the imbalance by detecting for each node whether there exists a discrepancy between the captured I/O activity and a forecasted I/O activity used to distribute the database tables across the plurality of nodes, further wherein the performed operation detects the imbalance by detecting for each node whether fragmentation exists in connection with the database tables by comparing a number of deletions in connection with each of the nodes to a threshold;
• determine to reorganize the database tables on the one or more nodes based on the performed operation;
• and
• in response to said determination, reorganize the database tables, wherein the reorganizing includes dumping the database tables and redistributing the database tables to one or more nodes of the plurality of nodes.