Consolidating sql databases


Finally, Windows System Resource Manager (WSRM), a feature in Windows Server 2008, can be leveraged to partition and manage consolidated resources, which is a useful tool when consolidating.

Extras like these out-of-the-box technologies simplify business operations in a consolidated environment.

it can be defined simply as reduce the number of physical SQL servers, by migrating/moving different SQL databases running on different servers into one high performance server machine.

Early in the process of a consolidation project, you will create a profile to help identify which applications are good candidates for consolidation.

Through consolidation, organizations have an opportunity to decommission legacy SQL Server instances and physical servers, leading to a decrease in management and financial obligations.