Considerations for database server consolidation

- 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,…