Finally, you'll cover just about every option for migrating databases and servers from one location to another.
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. He has worked with SQL server for the past 15 years, in a variety of roles including DBA, Lead DBA, and multi-department manager, which have given him extensive experience planning and implementing large-scale environment changes and upgrades.
One of the first steps in SQL Server consolidation is to identify installations running on underutilized hardware.
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.
My first major consolidation effort was the result of SQL Server sprawl and an organization approaching an audit.
Experience with SQL Server installation and virtualization concepts is expected.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.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.
There are many reasons for consolidating SQL Server.