# US 2012/0254434 A1 · Placement goal-based database instance consolidation

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2012/0254434 A1
- Document ID: US20120254434A1
- Status: Published application
- Kind: A1
- Application number: 13/078,246
- Filed: 2011-04-01
- Published: 2012-10-04
- Earliest claimed: 2011-04-01
- Assignees: Microsoft Corporation
- Inventors: Prem N. Mehra; (Lindsey) Lingzhi Allen; (Cindy) Xue Song; (Johnson Li) Li Zhaofu; Michael C. Thomassy
- Web page: https://patentgrep.com/patent/US20120254434A1

## CPC

- G06F 16/20: of structured data, e.g. relational data
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- H04L 69/329: in the application layer [OSI layer 7]
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

Models and tools for facilitating database instance consolidation are described. One approach obtains standardized database instance performance data, receives instance isolation criteria which are applied to divide instances into sets, determines resource usage for each set, and assigns instance sets to target machines based on resource usage and capacity. Each instance set is associated with a virtual machine in some cases. A security isolation criterion indicates that specified instances shall not co-reside on a target machine; an organizational criterion indicates that specified instances shall be located together in a single data center; a compatibility criterion indicates that instances shall not reside in the same virtual machine, the same physical server, or the same server pool. Users iteratively reach an acceptable consolidation of instances at one or more data centers, such as an enhanced assignment of instances that is more efficient than a linear additive solution.

## Claims

### Claim 1

A computer-readable non-transitory 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;
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.

### Claim 2 (depends on 1)

The configured medium of claim 1, wherein at least one of the following is received as a database instance isolation criterion:
a security isolation criterion indicating that specified instances shall not co-reside on a target machine;
an organizational isolation criterion indicating that specified instances shall be located together in a single data center.

### Claim 3 (depends on 1)

The configured medium of claim 1, wherein determining a resource usage for each instance set comprises rounding up to a multiple of a predetermined utilization unit.

### Claim 4 (depends on 1)

The configured medium of claim 1, wherein assigning instance sets to target machines comprises sorting target machines by resource capacity.

### Claim 5 (depends on 1)

The configured medium of claim 1, wherein assigning instance sets to target machines comprises utilizing an additive linear approach.

### Claim 6 (depends on 1)

The configured medium of claim 1, wherein the process further comprises associating each instance set with a virtual machine, and assigning instance sets includes assigning virtual machines to target machines.

### Claim 7 (depends on 6)

The configured medium of claim 6, wherein determining a resource usage for each instance set comprises finding a virtual machine resource usage for each virtual machine.

### Claim 8 (depends on 1)

The configured medium of claim 1, wherein assigning instance sets to target machines comprises entering at least one isolation criterion into a spreadsheet program.

### Claim 9

A process for placement goal-based database instance consolidation, the process comprising the steps of:
gathering database instance performance data for database instances running on source machines;
standardizing gathered performance data;
entering into a user interface of a consolidation tool at least one database instance placement goal in the form of at least one isolation criterion;
identifying target machine characteristics to the consolidation tool;
commanding the consolidation tool to apply one or more database isolation criteria to the standardized performance data and the target machine characteristics; and
getting from the consolidation tool an assignment of instances to target machines.

### Claim 10 (depends on 9)

The process of claim 9, wherein standardizing gathered performance data includes at least one of the following:
setting a Needed Compute Unit to a Normalized CPU Capacity times a Processor Time Percentage;
setting Needed Compute Unit to a Normalized CPU Capacity times a Processor Time Percentage times a multiplier which exceeds one;
setting a Virtual Machine Compute Unit to a Target Machine Compute Unit divided by a Target Machine Number of Processors and times a Virtual Machine Number of Processors, when Virtual Machine Number of Processors does not exceed Target Machine Number of Processors;
setting a Virtual Machine Compute Unit to a Target Machine Compute Unit when a Virtual Machine Number of Processors exceeds a Target Machine Number of Processors;
setting a Virtual Machine Memory Usage based on a Virtual Machine Startup Memory Allocation and a Virtual Machine Maximum Memory Allocation.

### Claim 11 (depends on 9)

The process of claim 9, wherein the entering step comprises entering at least one isolation criterion into a spreadsheet program, and the spreadsheet program serves as at least a portion of the user interface of the consolidation tool.

### Claim 12 (depends on 9)

The process of claim 9, wherein the getting step gets an assignment of instances for at least one of the following situations:
source machines are treated as being located in multiple data centers and target machines are treated as being located in multiple data centers;
source machines are treated as being located in multiple data centers and target machines are treated as being located in a single data center;
source machines are treated as being located in a single data center and target machines are treated as being located in multiple data centers;
source machines are treated as being located in a single data center and target machines are treated as being located in a single data center.

### Claim 13 (depends on 9)

The process of claim 9, wherein the entering step comprises entering at least one isolation criterion which is based on at least one of the following: a Security Factor, an Organizational Factor, a Compatibility Factor.

### Claim 14 (depends on 9)

The process of claim 9, wherein the entering step comprises entering a security isolation criterion which indicates that specified instances shall not co-reside on a target machine.

### Claim 15 (depends on 9)

The process of claim 9, wherein the entering step comprises entering an organizational isolation criterion which indicates that specified instances shall be located together in a single data center.

### Claim 16

A computer system configured to assist database instance consolidation, the system comprising:
a logical processor;
a memory in operable communication with the logical processor;
at least one database instance isolation criterion residing in the memory; and
database instance consolidation code residing in the memory and capable of automatically applying the database isolation criterion to divide database instances into instance sets and capable of automatically assigning instance sets to target machines based on instance set resource usage and target machine resource capacity.

### Claim 17 (depends on 16)

The system of claim 16, wherein the system is further characterized by standardized database instance performance data residing in the memory, and the database instance consolidation code is also capable of determining a resource usage for each instance set based on the performance data.

### Claim 18 (depends on 16)

The system of claim 16, wherein the database instance consolidation code comprises a spreadsheet program which is programmed to automatically assign instance sets to target machines based on instance set resource usage and target machine resource capacity.

### Claim 19 (depends on 16)

The system of claim 16, wherein the database instance consolidation code is programmed to assign instance sets to target machines based at least in part on an additive linear calculation model.

### Claim 20 (depends on 16)

The system of claim 16, further characterized in that a particular Needed Compute Unit resides in the memory, namely, a Needed Compute Unit which is defined as a Normalized CPU Capacity times a Processor Time Percentage.
