Performance of an OLTP application on symmetry multiprocessor system

摘要: Sequent's Symmetry Series is a bus-based shared-memory multiprocessor. System performance in an OLTP relational database application was investigated using the TP1 benchmark. tested with fully-cached benchmarks and scaled benchmarks. In tests, entire fits inside main memory. larger than available benchmark, initially limited by bus saturation. The cause transfer of process context from processor to processor. This eliminated assigning each Processor affinity combined reductions message-passing within database. Throughput dramatically improved. tests were I/O bound. bottleneck can be connecting more disk drives, or increasing memory size.