Optimize and Consolidate SQL Server
Get more from your SQL Server deployment.
RETIRED CONTENT
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. |
|
| 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. |
|