Strategies associated with SQL Server consolidation include: .
The main benefit of this approach is the drastic reduction in total cost of ownership (TOC).
Some foundational topics and terminology will be included to provide the basis for the discussion, because some terms or strategies might be worded differently in other papers.
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.
One of the important components in the IT environment is the database.
Databases tend to be very widespread across the enterprise, because they are very efficient for handling relational storage of data and are designed to be platforms for a wide variety of applications.
Thus databases are one of the prime candidates for consolidation.