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 » testing » Benchmark » Performance   (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: memory effectiveness of virtualization

    One of the key performance metrics on any computer system is its memory speed (or memory bandwidth).   Memory speed can be measured in many different ways at different levels. At the OS level, one way to measure memory speed is to clock how fast (in terms of megabytes/gigabytes per second) it can read a piece of data from a memory location ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 29, 2009
  • Large Query Performance and Query Parallelism

    [2008/08/25] This post has been modified significantly to correct some inaccurate statements because I mis-read Joe Chang's post. Joe Chang posted some interesting results using the TPC-H queries with the scale factor set to 10. I happened to have done something similar, and naturally noticed a rather significant difference between his results ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on August 24, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement