Consolidating sql servers best practices
There are many reasons for consolidating SQL Server but license and hardware cost reduction have always been primary drivers for organizations to consolidate.In this course, SQL Server: Consolidation Tactics and Best Practices, you'll start with general considerations for consolidation that should be thought about and completed before any planning, as well as ways that to identify consolidation candidates' recommendations for which type of servers to consider consolidating first.Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. We will explore three consolidation methods: using a large single instance, using a multiple instance server, and using virtualization.I will explain the benefits of each consolidation method as well as the risks associated with them, and I'll also share some considerations and personal experiences I've had.It is worth mentioning, however, that consolidating too many databases onto a single instance can bring about performance degradation and resource contention.
This is especially true in large organizations with SQL Server infrastructures, where IT staffs often find themselves running many underutilized SQL Server installations.
You'll then learn about three consolidation methods: using a large single instance, using a multiple-instance server, and using virtualization.