Technical Reference Guides for Designing
Mission-Critical OLTP Solutions
The guides in the series, Technical Reference Guides for Designing OLTP Solutions, assist with the planning and design of online transactional processing (OLTP) in SQL Server. These guides reflect the knowledge gained by Microsoft while working with customers on mission-critical deployments. Each guide provides not only the key technical concepts and information helpful for design, but also “lessons learned,” best practices, and references to customer case studies. Most of the information in these guides tends not to be version specific and spans concepts consistent from Microsoft SQL Server 2005 through Microsoft SQL Server 2008 R2.
Use these technical reference guides after you have made the conceptual architectural decisions to address specific business needs and are ready to work through the technical design alternatives to choose a solution.
To open a guide, click on the corresponding text in the following diagram.
Online Transaction Processing (OLTP)
- Transactional Processing
- Batch Processing
- Beyond Relational
- Data Center Optimization
- High Availability & Disaster Recovery
- Data Access
- Online Transaction Processing (OLTP)