THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » performance » TPC-C   (RSS)
  • Performance impact: hyperthreading for OLTP queries

    My previous post focuses on the performance impact of enabling hyperthreading (HT) on a machine with four Intel Westmere-EX processors on reporting queries. Let’s turn our attention to OLTP queries. To oversimplify it, reporting queries are generally processed by scanning a large number of pages, whereas quick index seeks are the hallmark of OLTP ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 5, 2012
  • Evaluating server hardware: a sign of the times

    For nearly ten years, I have had success in using a specifically modified version of the TPC-C benchmark for evaluating server hardware running SQL Server. Depending on your purpose, you can evaluate computer hardware in numerous ways with numerous benchmarks. Arbitrarily picking a generic benchmark to evaluate a server is of no interest to me. ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 3, 2012
Privacy Statement