Optimize and Consolidate SQL Server

Get more from your SQL Server deployment.

Onsite Workshop

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.

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

Workshop icon 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.

Book a Workshop View Blueprint
Visit our IT Cost Optimization Center
Over 100 analysts waiting to take your call right now: 1-519-432-3550 x2019
Contact Us