Patent ID: 8667020

Claim:
A computer-readable storage medium configured with data and with instructions that when executed by at least one processor causes the processor(s) to perform a process for facilitating database instance consolidation, the process comprising the steps of: obtaining standardized database instance performance data for database instances running on source machines; receiving at least one database instance isolation criterion, wherein at least one isolation criterion includes at least one of the following: (a) a security factor indicating that specified instances shall not co-reside on a target machine, (b) an organizational factor indicating that specified instances shall be located together in a single data center, (c) a compatibility factor indicating that specified instances shall not reside in the same virtual machine, (d) a compatibility factor indicating that specified instances shall not reside in the same physical server, or (e) a compatibility factor indicating that specified instances shall not reside in the same server pool; applying at least one received database isolation criterion to automatically divide database instances into instance sets; determining a resource usage for each instance set; and automatically assigning instance sets to target machines based on instance set resource usage and target machine resource capacity, and utilizing at least one of the following: dynamic programming, combinatorial optimization.