Advantages consolidating databases

Thus databases are one of the prime candidates for consolidation.

When consolidating database applications, consider the following three potential strategies: using a single physical machine to host multiple virtual machines (VMs) running Microsoft® SQL Server® data management software, using a single machine to host multiple SQL Server instances, and using a single instance of SQL Server to host multiple databases.

advantages consolidating databases-57

To further increase top-line revenue, many companies will open new office locations and embrace additional sales channels resulting in more sophisticated processes for ecommerce integration, recurring billing, financial consolidation, amongst others.

Additional business software to support these processes can take the form of standalone applications from different vendors, homegrown applications, or a variety of spreadsheet workarounds.

As a consequence, various disparate applications are installed at different points in time in various functional areas, resulting in business process inefficiencies and software integration challenges.

But how did these problems arise in the first place, and how can they be avoided?

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

It is worth mentioning, however, that consolidating too many databases onto a single instance can bring about performance degradation and resource contention.

These technologies' implementations can and do depend on the needs of the business and the sensitivity/confidentiality of the data stored in the database, and the price the business is willing to spend on ensuring data security, consistency and integrity.

When discussing access to distributed databases, Microsoft favors the term distributed query, which it defines in protocol-specific manner as "[a]ny SELECT, INSERT, UPDATE, or DELETE statement that references tables and rowsets from one or more external OLE DB data sources".

Strategies associated with SQL Server consolidation include: .

Tags: , ,