Join Martin Guidry for an in-depth discussion in this video Considerations for database server consolidation, part of Designing Database Solutions for SQL Server 2012.
- In this section I'd like to talk about…Database Server Consolidation.…If you have multiple Microsoft SQL servers running,…you could move all of the databases off of one server,…put them on another server,…and then retire that server that is no longer being used.…There can be some advantages…and disadvantages to doing this.…So in this section we're going to talk about…reasons to consolidate,…and reasons not to consolidate.…First, the Reasons to Consolidate.…Well, hopefully it will lead to a simpler infrastructure.…
Every time we reduce the number of servers…we reduce the amount of things we have back up,…the amount of things we have to maintain,…the amount of things we have to apply…service packs and hot fixes to.…If you have hundreds of servers…and you're talking about just turning off one or two,…then the difference probably isn't that great.…The difference between managing 98 servers…versus managing 100 servers is not really a big difference.…But if you only have two SQL servers…and you're thinking about consolidating down to one,…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.