SQL Server Logo

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 access these guides, you may use the visual hierachy (i.e., image map) that provides a visual representation of the relationship between the guides or through a bulleted hierarchical list.

To open a guide, click on the corresponding text in the following diagram.

SQL Server---a Technical Reference Guide for Designing OLTP Solutions SQL Server OLTP---a Technical Reference Guide for Designing OLTP Solutions Transactional Processing (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Batch Processing (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Relational Data (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Beyond Relational Data (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Remote BLOB Storage (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Spatial Data (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Integrated Full-Text Search (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions XML (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions FileStream (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Scale-Up (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Scale-Out (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Transparent Scale-Out (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Replication (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Application-Driven Scale-Out (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Asynchronous Scale-Out (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Synchronous Framework (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Data Center Optimization (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Backup & Restore (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Database Maintenance (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Software Maintenance (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Version Upgrade (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Agents & Jobs (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Monitoring (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Compliance (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Governance (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Security (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions High Availability & Disaster Recovery (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Database Mirroring (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Failover Clustering (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Data Access (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions UDT, UDF, & SQLCLR  (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Transactions (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Distributed Transactions (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Data Access Layer (SQL Server OLTP)---a Technical Reference Guide for Designing OLTP Solutions Technical Reference Guides for Designing OLTP Solutions --- Visual Hierarchy