Consolidating sql servers best practices
By relocating servers to fewer sites, reducing the number of servers, and merging data on to fewer servers and centralized storage devices, the hardware savings alone are significant.
My first major consolidation effort was the result of SQL Server sprawl and an organization approaching an audit.
The benefits of each consolidation method are explained as well as the risks associated with them, plus some considerations and practical experiences.
Finally, you'll cover just about every option for migrating databases and servers from one location to another.
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.
I wrap up the course going over various migration strategies.
Search for consolidating sql servers best practices:
By the end of this course, you'll have the skills required to plan and execute a consolidation project or an upgrade of your SQL Server environment, and you'll be well-versed in all the tactics that help reduce your SQL Server licensing requirements.