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.
Download the IPD Guide for Microsoft SQL Server 2008 and SQL Server 2008 R2 at http://go.microsoft.com/fwlink/?LinkId=160982
What’s New in Microsoft SQL Server 2008 R2
Built on SQL Server 2008, SQL Server 2008 R2 has expanded reporting and analytics through self-service business intelligence.
• Master Data Services. With Master Data Services, IT organizations can centrally manage critical data assets companywide and across diverse systems, enable more people to securely manage master data directly, and ensure the integrity of information over time.
•Improved application and multi-server management capabilities.
•The SQL Server Utility allows DBAs to centrally manage and view instances of SQL Server, data-tier applications, database files, and volumes.
•The Utility Control Point (UCP) collects configuration and performance information from managed instances of SQL Server every 15 minutes, and provides dashboard views of health summary of SQL Server resources.
•Data-tier applications (DAC), which contain all of the database’s schema, dependent objects, and deployment requirements used by an application to improve the deployment of data applications and the collaboration between data-tier developers and DBAs.
•Utility Explorer dashboards to monitor resource utilization and health states.
•Two new premium editions. SQL Server 2008 R2 introduces two new premium editions to meet the needs of large-scale datacenters and data warehouses: Datacenter and Parallel Data Warehouse.
•Integration with Microsoft SQL Azure. The client tools included with Microsoft SQL Server 2008 R2 allows DBAs to connect to SQL Azure, a cloud-based service that offers a flexible and fully relational database solution in the cloud.
•Integration of SQL Server with Sysprep. Allows DBAs to automate the deployment of SQL Server.
•Analysis Services integration with SharePoint. SQL Server PowerPivot for SharePoint is a new role-based installation option in which PowerPivot for SharePoint will be installed on a new or an existing SharePoint 2010 server to support PowerPivot data access in the farm.
•See http://msdn.microsoft.com/en-us/library/cc645993.aspx for more detailed information on features in specific versions of SQL Server 2008 and http://msdn.microsoft.com/en-us/library/cc645993(SQL.105).aspx for SQL Server 2008 R2.
Determine capacity and performance requirements
•Disk storage required. For databases that don’t yet exist, an estimate will need to be made of the disk storage required. Storage needs should be calculated for the database, transaction log, indexes, and tempdb database.
••IOPS and throughput required. Since the main function of SQL Server is to manipulate data, and that data resides either in memory or on the I/O subsystem, any I/O performance problems will result in performance degradation of SQL Server. Although it may not be possible to calculate the required IOPS in advance, benchmarks for some workloads may be available from SAN and disk vendors that may provide a baseline for estimating the required performance and the disk storage configuration required to deliver that performance level.
More information about the IPD series:
The Infrastructure Planning and Design guides are the next version of Windows Server System Reference Architecture. The guides in this series help clarify and streamline design processes for Microsoft infrastructure technologies, with each guide addressing a unique infrastructure technology or scenario. All guides share a common structure including:
- Definition of the technical decision flow through the planning process.
- Listing of decisions to be made and the commonly available options and considerations.
- Relating the decisions and options to the business in terms of cost, complexity and other characteristics.
- Framing decisions in terms of additional questions to the business to ensure a comprehensive alignment with the appropriate business landscape.
- These guides complement product documentation by exposing and focusing on infrastructure design options.