THE SQL Server Blog Spot on the Web

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

Browse by Tags

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

    This is in part a response to a comment by Paul White (@SQL_Kiwi) to my previous post on the performance impact of enabling hyperthreading (HT) on OLTP queries, and in part due to my desire to capture a more complete set of test data for future investigation on this very topic. I’m posting below the results of re-running the same exact test as ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 11, 2012
  • 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
  • Performance impact: hyperthreading for reporting queries

    There are a lot of questions on hyperthreading, but not a lot of answers.  There is no shortage of opinions, but very few are based on significant first hand experience or solid test data. We know that the hyperthreading technology in the older generations of the Intel processors was not well received by the SQL Server community. ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 5, 2012
  • Poll: Hyperthread or not on 2 x 4 core Nehalem SQL Server?

    Common wisdom with previous generations of server hardware was that SQL Server might not benefit from hyperthreading or could be degraded at high CPU usage; does anyone have definitive data about Nehalem (non-EX) servers and SQL Server 2005 or 2008? Here are some ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on January 14, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement