Chapter 32. Distributed Transaction Processing

by Paul Bertucci


  • Distributed Transaction Processing

  • Distributed Queries

  • Linked Servers

  • Distributed Transactions

  • MS DTC Architecture

To take advantage of distributed databases (data), you need to understand their capabilities, their management, and the monitoring and tuning considerations that are unique to them.

With the rapid deployment and massive increase of new computers and databases throughout a company's infrastructure, ways to harness this distributed data are becoming one of the top needs (and top problems!). Microsoft's latest version of the Distributed Transaction Coordinator (MS DTC) for SQL Server 2000 has become one of the best and most self-contained distributed transaction managers around. It takes advantages of numerous capabilities that provide a company with an environment to make use of its data no matter where it is. This chapter will outline the main features of MS DTC (within Component Services), identify what you need to look out for with MS DTC, and show how to build up and execute a distributed transaction that is controlled by MS DTC.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features