Server consolidation with SQL Server

This session will provide attendees with an insight into running a SQL Server consolidation project.  We will cover the crucial points to ensure successful server consolidation from both technical and business perspectives. Here's a summary of the session:

  • Business and technical drivers
    • Why consolidate?
    • Type of consolidation (physical, storage, geographic)
  • Planning and considerations
    • Key considerations (SQL Server behaviour/ characteristics in shared environments disk/ CPU/ memory)
    • Designing SQL instance and common configurations
  • Guiding principles for consolidation Design and implementation
    • Consolidation process
    • Migration Tools
  • Potential issues and solutions
    • Shared components (schedulers, buffer pool, procedure cache, disk IO, tempdb)
    • Using Windows Server Resource Manager or Resource Governor
Presented by Justin Langford at SQLBits V
  • Downloads
    Video available WMV Video 192 MB
  • SpeakerBIO

    Justin is a Principal Consultant for Coeo, a Microsoft Gold Partner providing SQL Server consulting services for upgrade, performance tuning, scalability and availability solutions for SQL Server.  Coeo also offer Remote DBA services for mission critical SQL Server platforms.  Justin is an MVP and co-authored Wrox IT Pro: SQL Server 2012 Internals and Troubleshooting, as well as the same title for SQL Server 2008 and SQL Server 2005 Performance Tuning.
  • Video