By submitting your email address, you agree to receive emails regarding relevant topic offers from Tech Target and its partners. Contact Tech Target at 275 Grove Street, Newton, MA. This is especially true in large organizations with SQL Server infrastructures, where IT staffs often find themselves running many underutilized SQL Server installations.An underutilized SQL Server can result in increased hardware and management costs, lack of standardization and other challenges associated with business continuity.

consolidating data multiple sources-45

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.

Therefore, organizations should size their workloads and hardware appropriately.

Some organizations might be prevented from consolidating all of their databases onto a single SQL Server instance.

Below are examples of situations where organizations may need to maintain more than one instance: Those situations make it clear that a single instance is not always possible.

But even in situations like those, it is still common for organizations to consolidate to fewer SQL Server hosts and experience a reduction in TCO.By now, many of you are familiar with Hyper-V, Microsoft's virtualization technology that is out of the box with Windows Server 2008.For example, SQL Server instances and databases using less than 30% of their hardware's processor, memory and disk space are excellent candidates for consolidation.With numerous options available, organizations can choose a consolidation approach that aligns with their business model and day-to-day operations.Strategies associated with SQL Server consolidation include: .The main benefit of this approach is the drastic reduction in total cost of ownership (TOC).