SQL Server Consolidation at Micro.ppt

1、,SQL Server Consolidation at Microsoft,Published: March 2009,Microsoft IT operates thousands of SQLServer instances. Most reside on dedicated physical hardware and are typically underutilized. MicrosoftIT wanted to reduce expenses by providing a utility for SQLServer instances.,Solution Overview,Bus

2、iness Challenge,Solution,Results/Benefits,MicrosoftIT produced the SQLUtility to improve SQLServer manageability through host consolidation, virtualization, and standardization.,Reduced operating and capital expenses Improved business continuity, scalability, and availability Improved environmental

3、sustainability Standardized build for SQLServer instances,Products and Technology,Windows Server 2008 SQL Server 2005 SQL Server 2008 Hyper-V SQL Utility Compute Utility Storage Utility,Positive Effects of Consolidation,Utilities in Microsoft IT,Identification of Underutilized Servers,Consolidation

4、Approaches,Three primary approaches Host consolidation Instance consolidation Database consolidation Microsoft IT used host consolidation to reduce risks such as SLA conflicts and shared resources,Virtualization Platform: WSRM vs. Hyper-V,Approach to resource management is an important decision Micr

5、osoft IT evaluated WSRM and Hyper-V and ultimately chose Hyper-V Microsoft IT uses Hyper-V to manage processor and memory use on host and guest partitions,Windows System Resource Manager,Hyper-V,Implementation of SQL Utility,Microsoft IT is implementing the SQL Utility in phases SQL Server hosts sch

6、eduled for EOL replacement are the first candidates for consolidation SQL Utility service is consumption based Selected implementation provides always-on high availability with flexible business continuity and disaster recovery,SQL Utility Architecture,Service Offerings,Service Offerings: Determinin

7、g the Configuration,Service Offerings: Hyper-V and the SDLC,Identification of Candidates for Migration,Microsoft IT uses several criteria to qualify candidate SQLServer instances for migration RightSizing data and capacity management guidance will guide server provisioning Monitoring ensures that a

8、new SQL Server instance does not adversely affect performance Host count and reduction in rack space and power consumption will determine success of phase 1,Attributes of System Quality,Availability and Business Continuity,SQL Utility deployment focuses on non-clustered SQL Server instances at this

9、time Microsoft ITidentified requirements and recommendations cover: Uptime General clustering Network adapter and network Cluster service Quorum,Availability and Business Continuity: Best Practices,Configure at least two of the cluster networks for internal cluster communication Design cluster netwo

10、rks to fail independently Do not connect multiple adapters on one node to the same network when not using teaming Ensure that two or more independent networks connect the nodes of a cluster Use identical network adapters,Availability and Business Continuity: Metrics,Availability and Business Continu

11、ity: Scorecard,Environmental Sustainability,Migrating SQL Server instances to the SQL Utility service decreases power consumption New servers may decrease data-center cooling needs Ability of new servers to host several instances of SQL Server reduces the data centers footprint Purchasing fewer phys

12、ical servers will mean less hardware to recycle,Manageability,Microsoft IT requirements for manageability: Take advantage of current database administration and automation tools Identify and develop operational processes for onboarding, upgrades, and failover Support previous, current, and future SQ

13、LServer versions Support the previous, current, and future IPAK Support CSSsupported environments,Provisioning,SQLUtility will eventually reduce the number of manual steps needed to deploy new SQLServer instances Virtual Machine Manager library will enable developers, testers, and production support

14、 teams to provide a consistent experience throughout the SDLC,Performance,Primary performance requirement for SQLUtility is providing equal or greater CUs, memory, and disk performance as the SQLServer instance used on its previous host Other requirements pertain to database and applications, read a

15、nd write operations, memory, and processor MicrosoftIT uses several performance-related guidelines for consolidation,Performance: Storage,Performance: Comparison of I/Os per Second,Performance: Latency Comparison,Performance: Stock Trading System Workload,Performance: Summary for Guest Configuration

16、s,Predictability and Repeatability,Application deployment and SDLCs frequently introduce risk of inconsistencies between environments SQL Utility will reduce or eliminate these inconsistencies by creating standard builds,Reliability,Overconsumption of shared resources in a consolidated environment w

17、as a key concern of SQL Server users Another concern was propagation of changes through the consolidated environment Operating system isolation in Hyper-V alleviated these concerns Primary reliability metric for SQL Utility is MTBF,Scalability,Scalability requirements of SQL Utility pertain to: CUs,

18、 memory, network bandwidth, and I/O throughput Storage performance Flexibility in moving an instance to a new host Adjustments to resource allocation Scalability through virtualization technology is much easier than with dedicated physical server hardware,Security,Hyper-V method of partitioning enab

19、les the traditional Microsoft IT security model to continue for production support teams Requirements for security are based largely on the policies laid out for MicrosoftIT deployments, including ACE policies,Monitoring,SQL Utility must meet requirements for service monitoring and control Monitorin

20、g requirements remain primarily the same as in a non-consolidated environment Monitoring services for the non-consolidated environment will continue to be used for the SQLUtility service,Supportability,SQLUtility will deploy only supported configurations of SQLServer Microsoft IT will anticipate fut

21、ure supported configuration scenarios and refine the service,Conclusion,SQL Utility is helping Microsoft IT reduce the number of data-center servers SQL Utility improves manageability SQLUtility provides and enhances business continuity, availability, scalability, and sustainability Project has met

22、early goals and will provide increasing value,For More Information,“Running SQL Server 2008 in a Hyper-V EnvironmentBest Practices and Performance Recommendations” SQLIO Disk Subsystem Benchmark Tool “Green IT in Practice: SQLServer Consolidation in MicrosoftIT” Standard Performance Evaluation Corporation ,For More Information,“SQL Server Automation Scripts” “Virtualization Strategy Provides Tools, Processes, and Compliance Capabilities to Enhance Business Support and Drive Adoption” “Identifying Server Candidates for Virtualization” Virtu