Optimize and Consolidate SQL Server

Get more from your SQL Server deployment.


Please note that the content on this page is retired. This content is not maintained and may contain information or links that are out of date.

Making changes to your enterprise database environment without considering best practices can:

  • Lead to extended downtime.
  • Result in decreased ROI.
  • Produce more project dead ends and increased operational costs.

Planning your implementation up front will help:

  • Improve database performance and unlock new features.
  • Transition smoothly to the new environment.
  • Communicate the project’s business value to stakeholders.

Book Your Workshop

Onsite Workshops offer an easy way to accelerate your project. If you are unable to do the project yourself, and a Guided Implementation isn’t enough, we offer low-cost onsite delivery of our Project Workshops. We take you through every phase of your project and ensure that you have a road map in place to complete your project successfully.

Module 1: Identify Opportunities and Challenges

The Purpose

  • Review the project rationale and identify project value add.
  • Identify challenges to overcome and opportunities to improve.

Key Benefits Achieved

  • Create an inventory of your current database environment.

Activities: Outputs:
1.1 Identify pain points in the current system.
1.2 Identify project drivers, risks, and expected outcomes.
  • Identify project value proposition
1.3 Identify stakeholders, SMEs, and roles and responsibilities.
  • Complete the project opportunity assessment
1.4 Establish project parameters and deliverables and collect system data.
  • Create an inventory identifying system interdependencies
1.5 Identify new features in SQL Server that can provide business value.

Module 2: Plan the Optimization Project

The Purpose

  • Develop a project plan to guide implementation.

Key Benefits Achieved

  • Develop project scope and get sign-off.

Activities: Outputs:
2.1 Review key factors for your platform, such as security and availability, to identify the optimal path for modifications.
  • Document prioritized criteria to guide any modifications to your environment
2.2 Identify the paths to optimization that can help you meet business goals.
  • Complete the opportunity assessment and identify initial steps on the project checklist
2.3 Identify servers to upgrade, performance tune, and consolidate.
  • Complete the TCO budget tool

Module 3: Test, Execute, Stabilize, and Debrief

The Purpose

  • Establish a plan to execute and test modifications to your environment.
  • Communicate project successes to stakeholders.

Key Benefits Achieved

  • Ensure your plan to modify your SQL Server environment will minimize disruption to business processes.
  • Build a roadmap for next steps to streamline future projects.

Activities: Outputs:
3.1 Create a step-by-step plan for modifications with your SMEs.
  • Complete the execution checklist
3.2 Identify steps for roll back and backup to deal with unexpected complications.
  • Complete the roll back checklist
3.3 Review your project plans with stakeholders.
  • Review the executive presentation
3.4 Discuss and document lessons learned.
  • Update the issue resolution template
Visit our Exponential IT Research Center
Over 100 analysts waiting to take your call right now: 1-519-432-3550 x2019