To meet the demands of database growth multiple SQL Servers are added again and again leading to wasted hardware and licenses, a lack of standards within the enterprise and security holes. In the first chapter of this three part eBook from SearchSQLServer.com, SQL Server expert Hilary Cotter explains how to reduce the difficulties of managing multiple SQL Servers by implementing server consolidation strategies. A well planned consolidation strategy increases performance, reliability and more.
Also included in this chapter:
- An explanation of the cause of causes of SQL Server sprawl
- The challenges of patching large number of SQL Servers
- How consolidation creates efficiency through improved uptimes, performance and monitoring
- What to consolidate: server and storage consolidation and the different approaches
- Key questions to ask when assessing SQL Server and storage consolidation
SQL Server Research Library 
