Advantages consolidating databases
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.
Today the distributed DBMS market is evolving dramatically, with new, innovative entrants and incumbents supporting the growing use of unstructured data and No SQL DBMS engines, as well as XML databases and New SQL databases.
Proper planning of an integrated business management software system often takes a back seat to short-term revenue acceleration goals.
Fortunately, by using SQL Server 2008 on Windows Server 2008, organizations can successfully address the issues associated with underutilization by consolidating SQL Server instances and databases onto fewer physical or virtual servers.
One of the first steps in SQL Server consolidation is to identify installations running on underutilized hardware.
Besides distributed database replication and fragmentation, there are many other distributed database design technologies.
For example, local autonomy, synchronous and asynchronous distributed database technologies.