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 » SQL Server 2005   (RSS)
  • 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
  • Performance Impact: Bookmark Lookup is Expensive - Even in Memory

    It’s well known that bookmark lookup (aka key lookup in case of a clustered index) is not cheap, especially when it comes to retrieving a lot of data. So I’m not going to rehash the pros and cons of bookmark lookup or why bookmark lookup is expensive. But I’ve noticed that when it comes to discussing bookmark lookup, all the literature seems ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 6, 2008
  • Performance Impact: Some Data Points on Read-Ahead

    In the next series of posts, I'll focus on SQL Server I/O, revisiting some common issues and taking a closer look at some others. In each post and as always, I'll make the case with specific data points from my tests. For the first two posts in this series, let me check out the read-ahead technique used by SQL server. Read-ahead is an important ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 4, 2008
  • SQL Server Checkpoint I/O Behavior

    Andrew Kelly in a recent post here advised visiting/revisiting the SQL Server I/O basics, and I completely agree. A firm grasp of the basics can make it easy to understand some system behaviors that otherwise may be puzzling at times. A question that is often asked is how SQL Server performs the I/O writes in its checkpoints. ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 19, 2008
  • A Rose By Any Other Name

    Regardless of the DBMS make or model, the transaction throughput curve of a database system is often shaped like a trapezoid. As the load level goes up initially, so does the transaction throughput. As the load level continues to go up, the transaction throughput will reach a plateau. After the load level is cranked up still further, the ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 20, 2007
  • Interview With Kalen Delaney About Inside Microsoft SQL Server 2005 Query Tuning and Optimization

    I am a big fan of Inside Microsoft SQL Server 2005 The Storage Engine so when I saw that yet another book got published in this series I just had to check it out. Inside Microsoft SQL Server 2005: Query Tuning and Optimization is very well written gets to the point and give you the answers that you need. I decided to contact Kalen to see if she ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on October 15, 2007
  • Performance Impact: The Potential Cost of Read_Committed_Snapshot

    In response to my previous blog post--Performance Impact: Setting a Database to Read Only, Shailesh Khanal mentioned that he observed significant performance degradation from READ COMMITTED SNAPSHOT OFF to ON for a read-only workload. This is counter intuitive since there is nothing in the version store if only SELECT statements are ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 4, 2007
Privacy Statement