Data Center Optimization (OLTP)---a Technical Reference Guide for Designing Mission-Critical OLTP Solutions

Want more guides like this one? Go to Technical Reference Guides for Designing Mission-Critical Solutions.

Companies employ a variety of processes to optimize their data centers to run efficiently and support critical business solutions. These processes range from enacting policies and procedures for change and release management to analyzing how data centers are built and maintained. Data center architecture relies on processes and people working with technology and operations. The objective is to optimize infrastructure, to achieve the business goals, solutions and application success. Enterprises often have a "run book" and other documented processes. For example, the features and discussions in the Microsoft Operations Framework documentation focus on the following:

  • Processes to plan, deliver, operate, and manage IT

  • Governance, risk, and compliance activities

  • Management reviews

  • Microsoft Solutions Framework best practices

Best Practices

The following resources provide examples of customer scenarios for data center optimization as well as general data center optimization reference material. (Note that the full URLs for the hyperlinked text are provided in the Appendix at the end of this document.)

Case Studies and References

The following articles provide examples of how you can optimize your data center:

  • The article How Microsoft IT Reduces Costs4 describes cost saving techniques.

  • In the Introduction5 to the “SQL Server 2000 Operations Guide,” the Microsoft Operations Framework is briefly discussed and related to the operations tasks and life cycle of Microsoft SQL Server 2000.

Questions and Considerations

This section provides questions and issues to consider when working with your customers.

  • Few companies treat their Microsoft Windows Server and SQL Server systems like their mainframes or other mission-critical systems. In many cases, these servers are treated as a sandbox environment, without tight change controls. Companies can better achieve their business objectives by adding standardized processes and procedures to their Windows Server and SQL Server environments and treating them more like mainframe systems.

  • Understand which vendors a customer is working with, prefers, or is looking to evaluate. This may drive some of their other processes, including database and server maintenance or high availability/disaster recovery (HA/DR) implementations.

  • What are operational best practices that the data center, operations, and infrastructure staff subscribe to or have put into practice? Examples might include IT infrastructure library (ITIL), Microsoft Operations Framework, Microsoft Solutions Framework, Sarbanes-Oxley, or their operations run book.

  • Are there specific goals or business-critical themes that the operations and infrastructure staff are trying to subscribe to (for example, reducing total cost of operation [TCO], reducing power use, or cooling/green initiatives)? Are there concerns or requirements such as HA or DR?

  • Understand where the data centers are located, how many data centers the company has, and any differences between the data centers. Also consider the networking and security systems and requirements.

  • Are there any specific compliance needs, such as payment card industry (PCI) compliance? If PCI compliance is needed, all data centers, including those used for DR, must be compliant.


Following are the full URLs for the hyperlinked text.

1 Microsoft Operations Framework 4.0

2 Chapter 1 – Introduction to the Microsoft Solutions Framework

3 Microsoft’s Top 10 Business Practices for Environmentally Sustainable Data Centers

4 How Microsoft IT Reduces Costs

5 SQL Server 2000 Operations Guide: Introduction