Server consolidation with SQL Server with Justin Langford - SQLBits 2019 - 27 Feb 2019 - 2 Mar 2019

It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

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

WMV Video 192 MB

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite. There is a breadth of knowledge in the SQL Community that will benefit everyone in the community. We want to spread that knowledge.

We all work with the SQL community, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.

Server consolidation with SQL Server

About

Useful information