dtj v08-04 1996

This document, a volume of the Digital Technical Journal from 1996, focuses on the Digital AlphaServer 4100 system, its architectural innovations, performance characteristics, and how software, particularly database products, leverages its capabilities.

The journal is structured around three main themes:

1. AlphaServer 4100 System Architecture and Performance:

   • The AlphaServer 4100 is presented as a new midrange symmetric multiprocessing (SMP) system, supporting up to four 400 MHz Alpha 21164 microprocessors and 8 gigabytes of Very Large Memory (VLM).
   • Its key performance advantages stem from low memory latency, high bandwidth, and low-latency I/O. It significantly outperforms previous-generation Alpha platforms and leading industry midrange systems, showing performance increases of 30% to 60% in memory-intensive workloads.
   • Detailed papers describe the cached processor module design (using synchronous B-cache and a duplicate tag store for cache coherency), the low-cost clock distribution system (achieving very low clock skew using off-the-shelf components), the CPU and memory architecture (optimized for low latency and high bandwidth using SDRAMs), and high-performance I/O design (including partial cache line writes, deadlock-free peer-to-peer transactions, and extensive buffering for large data bursts).

2. Oracle and Sybase Database Products for VLM:

   • This section highlights how leading database systems exploit the AlphaServer's VLM capabilities to overcome I/O speed limitations and maximize performance.
   • Oracle7's 64-bit Option for its Relational Database Management System is detailed, allowing direct access to memory in excess of 4 gigabytes. By enabling "Big Oracle Blocks" and "Large Shared Global Area," it achieves dramatic performance benefits for decision support systems, with some tests showing performance increases of up to 200 times.
   • Sybase System 11 SQL Server's VLM capabilities are also explored, noting its record-breaking TPC-C performance. Key features include the Logical Memory Manager (for fine-tuning buffer caches), a VLM query optimizer, and a "Housekeeper" thread that performs non-intrusive checkpoints, improving fast access and recovery.

3. Instruction Execution on Alpha Processors:

   • This part discusses the impact of adding byte and word manipulation instructions to the Alpha Architecture. Previously, such operations required multiple instructions.
   • An analysis of Microsoft SQL Server running on Windows NT demonstrated that these new instructions resulted in a performance increase of 3.5%, a reduction in executed instructions (4% to 7%), and a decrease in code size (up to 9%), validating the benefits of this architectural enhancement.

In essence, the document showcases the AlphaServer 4100 as a high-performance, cost-effective midrange server, highlighting the synergy between its advanced hardware design (especially its VLM support) and optimized software, leading to significant performance gains for commercial and scientific applications.