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. |
|
1.3 | Identify stakeholders, SMEs, and roles and responsibilities. |
|
1.4 | Establish project parameters and deliverables and collect system data. |
|
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. |
|
2.2 | Identify the paths to optimization that can help you meet business goals. |
|
2.3 | Identify servers to upgrade, performance tune, and consolidate. |
|
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. |
|
3.2 | Identify steps for roll back and backup to deal with unexpected complications. |
|
3.3 | Review your project plans with stakeholders. |
|
3.4 | Discuss and document lessons learned. |
|