Published: July 29, 2009 | Updated: February 17, 2012
Download the SQL Server Guide
About This Guide
The Infrastructure Planning and Design (IPD) Guide for Microsoft SQL Server 2008 and SQL Server 2008 R2 helps organizations address key design decisions and confidently plan the efficient implementation of a SQL Server infrastructure. The tasks addressed in this guide help technical decision makers identify the appropriate SQL Server roles needed as well as determine the infrastructure components, server placement, and fault-tolerance configuration necessary to meet planning requirements. By using this guidance, organizations can make efficient planning and optimal design decisions for their SQL Server infrastructures.
Figure 1. Decision flow chart
In More Detail
The Infrastructure Planning and Design Guide for Microsoft SQL Server 2008 and SQL Server 2008 R2 includes the following seven-step process:
- Step 1: Determine the Project Scope. This step involves determining the project scope to align the goals of the project with the business motivation.
- Step 2: Determine Which Roles Will Be Required. This step involves determining which SQL Server roles are required to support the business goals.
- Step 3: Design the SQL Server Database Engine Infrastructure. This step involves gathering the database requirements designing the database infrastructure from those requirements. Also, this step focuses on determining capacity and performance requirements, and deciding whether to place the database in a new or existing instance, and then whether to place the instance on a new or existing server running SQL Server.
- Step 4: Design the SQL Server Integration Services Infrastructure. This step involves determining the resource requirements and storage locations of the Integration services packages. Also, this step focuses on determining the number of SSIS servers required as well as where to place the SSIS server and SSIS roles.
- Step 5: Design the SQL Server Analysis Services Infrastructure. This step involves determining the resource requirements, the SQL Server version, whether scalable shared databases will be used, and the scaling needs. Also, this step focuses on whether to cluster and where to place the SSAS server and roles.
- Step 6: Design the SQL Server Reporting Services Infrastructure. This step involves determining the resource requirements and placement of the report server databases. Also, this step focuses on determining scaling and fault-tolerance, as well as the placement of the SSRS server.
- Step 7: Design the SQL Server Master Data Services Infrastructure. This step involves assessing the resource requirements, and planning the fault tolerance and scaling requirements. Also, based partly on these decisions, the database will be placed either on the same server as the Master Data Services web service or on a remote database server.
Join the IPD Beta Program
Subscribe to the IPD beta program and we will notify you when new beta guides become available for your review and feedback. They are open beta downloads. If you are not already a member of the IPD beta program, and would like to join, follow these steps:
- Go here to join the IPD beta program: https://connect.microsoft.com/InvitationUse.aspx?ProgramID=1587&InvitationID=IPDM-QX6H-7TTV&SiteID=14
If the link does not work for you, copy and paste it into the web browser address bar.
- Sign in using a valid Windows Live ID.
- Enter your registration information.
- Continue to the IPD beta program page, scroll down to Infrastructure Planning and Design, and click the link to join the IPD beta program.
Already a member of the IPD beta program? Go here to get the latest IPD beta downloads: https://connect.microsoft.com/content/content.aspx?ContentID=6556&SiteID=14
Please send questions or comments about this guide to firstname.lastname@example.org.
About Solution Accelerators
Solution Accelerators are authoritative resources that help IT pros plan, deliver, operate, and manage IT systems that address real-world scenarios. Solution Accelerators provide free, prescriptive guidance and automation to accelerate cross-product integration, core infrastructure development, and other enhancements.
Sign up to receive the Solution Accelerator Notifications newsletter so that you can stay informed about new Solution Accelerator releases and updates. The newsletter covers such areas of interest as:
- Communication and collaboration
- Security, data protection, and recovery
- Operations and management
Download the SQL Server Guide