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. System performance was tested with fully-cached benchmarks and with scaled benchmarks. In fully-cached tests, the entire database fits inside main memory. In scaled tests, the database is larger than available memory. In the fully-cached benchmark, performance was initially limited by bus saturation. The cause was the transfer of process context from processor to processor. This was eliminated by assigning each process to a processor. Processor affinity was combined with reductions in message-passing within the database. Throughput was dramatically improved. The scaled tests were I/O bound. This bottleneck can be eliminated by connecting more disk drives, or by increasing the main memory size.
Sequent的Symmetry系列是基于总线的共享内存多处理器。使用TP1基准调查了OLTP关系数据库应用程序中的系统性能。系统性能已通过完全缓存的基准和扩展基准进行了测试。在完全缓存的测试中,整个数据库都可以放入主内存中。在扩展测试中,数据库大于可用内存。在完全缓存的基准测试中,性能最初受到总线饱和度的限制。原因是进程上下文在处理器之间转移。通过将每个进程分配给处理器,可以消除这种情况。处理器亲和力与数据库中消息传递的减少相结合。吞吐量得到了显着提高。规模化测试受I / O约束。可以通过连接更多磁盘驱动器或增加主内存大小来消除此瓶颈。 P>
机译:使用OLTP工作负载的CC-NUMA多处理器性能评估
机译:消除混合工作负载的神话:除了传统观点之外,在同一个数据库上运行DSS和OLTP应用程序的真正性能含义是什么?
机译:消除混合工作负载的神话:除了传统观点之外,在同一个数据库上运行DSS和OLTP应用程序的真正性能含义是什么?
机译:OLTP应用程序在对称多处理器系统上的性能
机译:基于芯片多处理器(CMP)的系统上HPC应用程序的性能预测
机译:运动系统中任务诱导的对称性和归约及其在针转向中的应用
机译:针对多处理器片上系统的流应用的架空感知系统级联合能量和性能优化