skip to content »

Consolidating sql servers

With numerous options available, organizations can choose a consolidation approach that aligns with their business model and day-to-day operations.

consolidating sql servers-29

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.This course starts with general considerations for consolidation where I cover things that you should be thinking about and doing before you even plan your consolidation strategy.I cover ways that you can identify consolidation candidates in your environment and make recommendations on which type of servers you should consider consolidating first.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.You'll then learn about three consolidation methods: using a large single instance, using a multiple-instance server, and using virtualization.

The benefits of each consolidation method are explained as well as the risks associated with them, plus some considerations and practical experiences.

I hope you'll join me as we explore the benefits and risks of consolidating SQL Server with this course, SQL Server: Consolidation Tactics and Best Practices, here on Pluralsight.

This is especially true in large organizations with SQL Server infrastructures, where IT staffs often find themselves running many underutilized SQL Server installations.

Hello, my name is Tim Radney, and welcome to my course SQL Server: Consolidation Tactics and Best Practices.

I'm a Principal consultant with SQLskills, as well as a Microsoft Data Platform MVP, and I've been involved with SQL Server consolidation projects since 2008.

There are many reasons for consolidating SQL Server but license and hardware cost reduction have always been primary drivers for organizations to consolidate.