SQL Server: Consolidation Tactics and Best Practices
This course will show how to effectively plan and implement a consolidation strategy, including methods of consolidating, and ways to migrate databases and instances. This course is applicable to all versions of SQL Server.
What you'll learn
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. 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. 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.
Table of contents
- Introduction 2m
- Classify Your Instances 2m
- Benchmark Your Servers 4m
- Demo: Using Perfmon 10m
- More on Benchmarking Your Servers 3m
- Demo: Collecting Wait Statistics and File Statistics 3m
- Resource Bottlenecks 3m
- Go for the Easy Wins 2m
- Resource Management 2m
- Demo: Memory settings 2m
- VM Resource Management 2m
- Module Summary 1m
- Introduction 1m
- Benefits of a Large Single Instance 2m
- Risks with a Large Single Instance - Part 1 3m
- Risks with a Large Single Instance - Part 2 3m
- Considerations with a Large Single Instance 2m
- Demo: SSMS with Many Databases and Risk of SA Permissions 3m
- Demo: Buffer Pool Memory 1m
- Module Summary 1m
- Introduction 1m
- Detach, Copy, and Attach 2m
- Demo: Detach and Attach 2m
- SAN LUN Migrations 1m
- Database Mirroring / Log Shipping 1m
- Demo: Database Mirroring 1m
- Availability Groups 1m
- Physical to Virtual Migration 2m
- Virtual to Virtual Migration 2m
- Demo: Virtual to Virtual 3m
- Module Summary 2m
- Course Summary 5m
About the author
Tim has worked with SQL server for the past 25 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. Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passi... more